BlackBerry® Enterprise Service 10

[AndreasP]

Hello,

iam running the BES 5.0.3 and the Blackberry Monitoring Service with SQL Express 2005 and the BMSStore Database in a standard-installation environment. As the BESMgmt Database is about 30MB for half a year now the BMSStore is growing (of course because there is "old" data in the database) from day to day. The growth was ok for a while (the last 5 months), but within the last three weeks the size increased from about 300MB to 1GB exponentially. There are about 20 users connected to the BES.

As mentioned in this Thread, shrinking the database will free up about 7MB of space only. Is there a garbage collector job inside the BMS that will delete old data? Is it possible to delete old data inside the SMSS by trunking tables?

Best Regards

Andreas

[AndreasP]

An analysis of the database showed that the following two tables are very big:

dbo.DCS_database_tableindex_baseconfig

dbo.DCS_database_tableindex_statistics

The entries grow larger (with "lastmodtime") since 2012-03-26. New entries are added about all four minutes. At that date a new client license was added to the server and restarted. Is it possible to shrink that tables by deleting old entries?

In the BMS log files is no event that has changed to before 2012-03-26

[Erwann]

Hello,
I have the same problem, does anyone have a solution?
Thanks.

[AndreasP]

Anyone got a free support ticket to check it?

Perhaps ill make a snapshot of the virtual machine and delete the old entries in this tables and then try if the server works. But iam a bit afraid, cause all the management staff is connected to BES.

[knottyrope · Accepted solution]

How to trim the BlackBerry Monitoring Service database size

[AndreasP]

Hello knottyrope,

thx for this tipp, i tried it, but it doesn't shrink the database.

Just at this moment i deleted values from the two tables mentioned above. Currently it looks like that it works, so i know, the Monitoring Service is working.

[knottyrope]

What did you try?

can you export your Reg key please and post it here

[AndreasP]

I did not do something with reg keys (regedit)

I just deleted data records in the two tables

dbo.DCS_database_tableindex_baseconfig

dbo.DCS_database_tableindex_statistics

until there last entry* and then shrinked the database using Management Studio

* It seems that one complete data set is created all the time, so i just deleted all records to the last data set

[knottyrope]

---

AndreasP wrote:

I did not do something with reg keys (regedit)

---

Then it will grow again until you do or you can keep manually pruning it.

[AndreasP · Accepted solution]

Ill do it manually all 6 months i think