This article will explain to how set a fixed amount of memory for the BES SQL database to use.
- Download and install Microsoft SQL Server Management Studio Express
- Download the appropriate (standard or x64) version from the Microsoft SQL Server Management Studio Express website.
- Double click on the downloaded SQLServer2005_SSMSEE.msi installer
- Click Next
- Accept the license terms
- Click Next
- Enter your name/company name as needed
- Click Next
- Click Next
- Click Install
- Click Finish
- Launch Microsoft SQL Server Management Studio Express
- Click the Start menu
- Click All Programs
- Open Microsoft SQL Server 2005
- Launch SQL Server Management Studio Express
- Connect to Server
- Server Name: Your server should be selected by default
- Authentication: Windows Authentication (the default)
- Click Connect
- Right click on the Server Name within the Object Explorer pane
- Click Properties
- Click Memory
- Specify the Maximum server memory (in MB)
- Click OK
Additional Comments
Lowering the Maximum server memory to a low value can degrade the performance of the SQL database.