Deployment Guide

SQL Server Best Practices
The following list explains SQL Server best practices, which should be implemented when Dell security is installed if not already
implemented.
1. Ensure the NTFS block size where the data file and log file reside is 64 KB. SQL Server extents (basic unit of SQL storage)
are 64 KB.
For more information, search Microsoft's TechNet articles for "Understanding Pages and Extents."
2. As a general guideline, set the maximum amount of SQL Server memory to 80 percent of the installed memory.
For more information, search Microsoft's TechNet articles for Server Memory Server Configuration Options.
● Microsoft SQL Server 2012 - https://technet.microsoft.com/en-us/library/ms178067(v=sql.110)
● Microsoft SQL Server 2014 - https://technet.microsoft.com/en-us/library/ms178067(v=sql.120)
● Microsoft SQL Server 2016 - https://technet.microsoft.com/en-us/library/ms178067(v=sql.130)
● Microsoft SQL Server 2017 - https://technet.microsoft.com/en-us/library/ms178067(v=sql.130)
3. Set -t1222 on the instance startup properties to ensure deadlock information is captured if one occurs.
For more information, search Microsoft's TechNet articles for "Trace Flags (Transact-SQL)."
● Microsoft SQL Server 2012 - https://msdn.microsoft.com/en-us/library/ms188396.aspx
● Microsoft SQL Server 2014 - https://msdn.microsoft.com/en-us/library/ms188396.aspx
● Microsoft SQL Server 2016 - https://msdn.microsoft.com/en-us/library/ms188396.aspx
● Microsoft SQL Server 2017 - https://msdn.microsoft.com/en-us/library/ms188396.aspx
4. Ensure that all Indexes are covered by a weekly maintenance job to rebuild the indexes.
5. Validate that permissions and features are appropriate for the database leveraged by the Security Management Server. For
more information, see KB article SLN307771.
8
86 SQL Server Best Practices