If SQL Server is installed in a shared environment or if memory problems persist, you may change the amount of memory that SQL Server acquires for use.
By default, SQL Server is configured to behave as though it has exclusive access to the system on which it is installed, except for the operating system. SQL Server leaves sufficient memory available for the operating system to function without paging. SQL Server assumes it is running on a dedicated server and is not sharing the system with other resource-intensive applications. In this case, the default memory allocation assumption should not cause problems.
However, a typical Acoustic™ Tealeaf installation calls for SQL Server to reside on the Tealeaf Report server that contains several other memory intensive services.
If you need to change the memory that is allocated for SQL Server, complete the following steps.
- Log in to the server.
- Open SQL Server Management Studio.
- Login.
- In the Object Explorer pane, select <ServerProperties > Memory.
- In the
Maximum Server Memorytextbox, enter the amount of memory that you want to reserve for SQL Server, leaving enough memory to safely run other applications. - Restart the SQL Server service.