The following list explains SQL Server best practices, which should be implemented when Dell security is installed if not already implemented.
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."
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.
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)."
Ensure that all Indexes are covered by a weekly maintenance job to rebuild the indexes.