Space allocation in the BES Config Database for users
Posted 02-28-2011 at 04:05 AM by hdawg
Tags besmgmt, database size
So I just saw this KB article; neat point of information:
The maximum permitted record space for each BlackBerry smartphone user is 4850 KB in the BlackBerry Configuration Database and the average space required by each BlackBerry smartphone user is 400KB. A typical entry in the MsAddresses table in the BlackBerry Configuration Database is approximately 300 bytes in size. The MsAddresses table contains two copies of the contact list so that the BlackBerry smartphone user accounts can be managed. If more than two copies exist, the BlackBerry Mail Store Service uses a stored procedure to delete the extra copies nightly. The stored procedure deletes 3000 rows during each procedure call with a delay of 5 seconds between procedure calls.
The MSAddresses table contains the user lists and distribution lists that are located in the Microsoft® Active Directory®. Record data in the MSAddresses table uses approximately 1.043 KB of storage space. If the Microsoft Active Directory contains 100,000 items, the storage space for the table is approximately 100 MB.
Source
So while the average space is ~400KB, the max could hit 4850KB; at least you now know theoretically how big your BESMgmt could get.
The maximum permitted record space for each BlackBerry smartphone user is 4850 KB in the BlackBerry Configuration Database and the average space required by each BlackBerry smartphone user is 400KB. A typical entry in the MsAddresses table in the BlackBerry Configuration Database is approximately 300 bytes in size. The MsAddresses table contains two copies of the contact list so that the BlackBerry smartphone user accounts can be managed. If more than two copies exist, the BlackBerry Mail Store Service uses a stored procedure to delete the extra copies nightly. The stored procedure deletes 3000 rows during each procedure call with a delay of 5 seconds between procedure calls.
The MSAddresses table contains the user lists and distribution lists that are located in the Microsoft® Active Directory®. Record data in the MSAddresses table uses approximately 1.043 KB of storage space. If the Microsoft Active Directory contains 100,000 items, the storage space for the table is approximately 100 MB.
Source
So while the average space is ~400KB, the max could hit 4850KB; at least you now know theoretically how big your BESMgmt could get.
Total Comments 0
