791

How to set a fixed amount of memory for the BlackBerry Enterprise Server (BES) SQL database to use

This article will explain to how set a fixed amount of memory for the BES SQL database to use.

  1. Download and install Microsoft SQL Server Management Studio Express
    1. Download the appropriate (standard or x64) version from the Microsoft SQL Server Management Studio Express website.
    2. Double click on the downloaded SQLServer2005_SSMSEE.msi installer
    3. Click Next
    4. Accept the license terms
    5. Click Next
    6. Enter your name/company name as needed
    7. Click Next
    8. Click Next
    9. Click Install
    10. Click Finish
  2. Launch Microsoft SQL Server Management Studio Express
    1. Click the Start menu
    2. Click All Programs
    3. Open Microsoft SQL Server 2005
    4. Launch SQL Server Management Studio Express
  3. Connect to Server
    1. Server Name: Your server should be selected by default
    2. Authentication: Windows Authentication (the default)
    3. Click Connect
  4. Right click on the Server Name within the Object Explorer pane
  5. Click Properties
  6. Click Memory
  7. Specify the Maximum server memory (in MB)
  8. Click OK

Additional Comments

Lowering the Maximum server memory to a low value can degrade the performance of the SQL database.