If you are using Internet Explorer, please remove blackberry.com from your compatibility view settings.

Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

BlackBerry® Enterprise Service 10

Reply
Contributor
AndreasP
Posts: 17
Registered: ‎04-07-2011
My Device: Bold 9780
My Carrier: T-Mobile DE
Accepted Solution

BMSStore Database growing exponentially

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

Please use plain text.
Contributor
AndreasP
Posts: 17
Registered: ‎04-07-2011
My Device: Bold 9780
My Carrier: T-Mobile DE

Re: BMSStore Database growing exponentially

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

Please use plain text.
New Contributor
Erwann
Posts: 2
Registered: ‎07-02-2012
My Device: non-BlackBerry user

Re: BMSStore Database growing exponentially

Hello,
I have the same problem, does anyone have a solution?
Thanks.
Please use plain text.
Contributor
AndreasP
Posts: 17
Registered: ‎04-07-2011
My Device: Bold 9780
My Carrier: T-Mobile DE

Re: BMSStore Database growing exponentially

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.

Please use plain text.
Guru III
knottyrope
Posts: 29,925
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BMSStore Database growing exponentially

Please use plain text.
Contributor
AndreasP
Posts: 17
Registered: ‎04-07-2011
My Device: Bold 9780
My Carrier: T-Mobile DE

Re: BMSStore Database growing exponentially

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.

 

 

Please use plain text.
Guru III
knottyrope
Posts: 29,925
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BMSStore Database growing exponentially

What did you try?

 

can you export your Reg key please and post it here

 

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 5.0.4 and BES 10.2.2 with Exchange 2010 and SQL 2008


Please use plain text.
Contributor
AndreasP
Posts: 17
Registered: ‎04-07-2011
My Device: Bold 9780
My Carrier: T-Mobile DE

Re: BMSStore Database growing exponentially

[ Edited ]

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

Please use plain text.
Guru III
knottyrope
Posts: 29,925
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BMSStore Database growing exponentially


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.

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 5.0.4 and BES 10.2.2 with Exchange 2010 and SQL 2008


Please use plain text.
Contributor
AndreasP
Posts: 17
Registered: ‎04-07-2011
My Device: Bold 9780
My Carrier: T-Mobile DE

Re: BMSStore Database growing exponentially

Ill do it manually all 6 months i think

Please use plain text.