|
|
| | | | Configure Sql memory on a Server | 10/24/2008
1379 views | Problem: Server is getting very slow sometimes giving timeouts other times, just running slow. Cause: Lack of available memory causing the server to swap from memory to page file. Solution: Configure the max memory settings for each sql instance to not allow the server to use all the free memory Directions. Use this spreadsheet ( http://s3.amazonaws.com/CRMSupportFiles/SqlMemorySpreadsheet.xls ). |
|