10 Quick Tips for a CRM 2013 Database

Gayan Perera, 06 August 2014

Here is a collection of database tuning tips that will help you keep CRM and any other system that rely on SQL running smoothly and efficiently.


1.  Ensure a dedicated drive is allocated for each of the following: OS, Data, Logs, TempDB, Backups
2.  Ensure that each of the SQL drives are formatted with 64KB cluster size
3.  Ensure that all SQL data are stored inside folders and not in the root of the drive
4.  Ensure that TempDB is split across at least 4 files
5.  Ensure that DB log files are within the 10-15% size of the actual database
6.  Open the local security policy editor, navigate to user rights and set lock pages in memory and perform volume maintenance tasks to include the user running the SQL service
7.  Increase the page file to roughly 1.5x the size of the amount of memory allocated to the system
8.  Create a maintenance plan to rebuild indexes every couple of days
9.  Create a maintenance plan to update statistics every couple of days
10.  Avoid restarting the SQL server