In addition to ensuring the Integrity Server computer meets the requirements in the Readiness Checklist, Integrity requires a SQL Server database to store and process its data. To ensure optimum performance, you should properly configure the memory allocation of SQL Server.
Set the appropriate amount of memory to SQL Server. You should set 75% of memory for systems with 24 GB of RAM and above, or 50% of memory for system with below 24 GB or RAM.
To review and set the memory allocation:
-
Click Windows Start > Programs > Microsoft SQL Server 20xx > SQL Server Management Studio.
-
Connect to the Database Engine using the credentials supplied on site.
-
Right-click the instance at the top of the display, and then click Properties.
-
In the Server Properties window, select Memory in the left pane.
-
Change the Maximum server memory to the appropriate value in MB, and then click OK.