10-08-2009 02:54 PM
Does anyone know what BES actually uses its database for?
Does the DB hold static information such as a list of users, their PIN etc, or does it hold so much information that the BES refers to it everytime it sends a message?
We are looking to implement BES in a new site, and want to know what effect the BES database will have on our SQL server over there in terms of I/O, memory usage etc?
10-08-2009 04:45 PM
Which version BES on what mail platform and how many users and amount of mail servers?
MSDE can be user for up to 500 users after that you will need Full SQL.
Every time it sends a message a table is updated.
Everytime It policy is sent it is updated.
It policies are stored in it.
Software configs, groups, etc.
It does store PIN number and user info but not a whole lot of data.
All device backups are stored on the mail server.
Our dual 2.8ghz quad core server with 4 gig ram and 73 gig raid 1 OS and database area of 300 gig Raid 10 with 8 15k drives never goes above 4% usage with our users. We have 5 databases on it and yes it is total overkill but the CRM project was scrapped for now.
10-08-2009 05:16 PM
Thanks for answering.
We are running BES 4.1.6 across two servers, one seperate DB server running SQL 2000. We have about 1500 users.
So basically, if everytime a message is sent a table gets updated, then I guess that is a lot of transactions. Do you know what table and why gets updated whenever a message is sent?
10-08-2009 05:47 PM
10-09-2009 03:53 PM
When it comes to BES, the database stores EVERYTHING. User info, PINs, encryption keys, the works.
If you're finding the load on the SQL server is too high, it would be a good idea to get the database notification system (DBNS) up and running, especially given the number of users you have. Running the DBNS will significantly reduce the load on the SQL server and is considered a best practice when dealing with a remote database server.