Best practice: Testing with a new BlackBerry Configuration Database or a new Microsoft SQL Server
Microsoft® SQL Server® software hosts the BlackBerry® Configuration Database. If you are considering changes to the Microsoft SQL Server or the BlackBerry Configuration Database in your organization's environment, you can test the changes using the BlackBerry® Performance Engineering Resource Kit in your test environment.
Consider the following guidelines:
- Establish a baseline with the current Microsoft SQL Server or BlackBerry Configuration Database.
- Using the instructions for the software, install the new Microsoft SQL Server or BlackBerry Configuration Database.
- Run the tests using light, medium, and heavy workloads.
- Run multiple tests if possible to average out chance occurrences.
To check the performance of the BlackBerry Configuration Database, check the reports of the BlackBerry Infrastructure and Smartphone Simulator, but also check the reports of the performance monitor of the computer that hosts the Microsoft SQL Server.