A SQL server hosts the production and reporting databases. Correct SQL server configuration and correct settings on the computer that hosts the SQL server helps to improve the CCS performance.
The recommended settings are as follows:
Ensure that the SQL server is configured to use 75% of available physical memory (RAM). Perform the settings through the Memory tab of the SQL server properties dialog box.
Ensure that the page file size on the computer that hosts the SQL server is set to the value, system managed size and not to any specific value. To set the value in the System Properties dialog box, click the advanced tab and then click Performance. In the Performance Options dialog box click Settings and select the advanced tab. In the Virtual memory option, click Change and select, System managed size.
Ensure that the computer that hosts the SQL server has the latest updates. If not, then you must install the service packs along with the cumulative update package (if any) on the computer that hosts the SQL server. For example, If you have SQL 2008, then you should deploy Service Pack 2 on it.