Dell Data Protection | Encryption Manuel d'utilisateur télécharger pdf (Page 73)

Enterprise Server Installation and Migration Guide 73

Appendix B

SQL Server Best Practices

The following list explains SQL server best practices, which should be implemented when Dell Data Protection 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.”

• Microsoft SQL Server 2008 - http://technet.microsoft.com/en-us/library/ms190969%28v=sql.100%29

• Microsoft SQL Server 2008 R2 - http://technet.microsoft.com/en-us/library/ms190969(v=sql.105).aspx

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 2008 - http://technet.microsoft.com/en-us/library/ms178067%28v=sql.100%29

• Microsoft SQL Server 2008 R2 - http://technet.microsoft.com/en-us/library/ms178067%28v=sql.105%29

• Microsoft SQL Server 2012 - http://technet.microsoft.com/en-us/library/ms178067%28v=sql.110%29

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 2008 - http://technet.microsoft.com/en-us/library/ms188396%28v=sql.100%29

• Microsoft SQL Server 2008 R2 - http://technet.microsoft.com/en-us/library/ms188396%28v=sql.105%29

• Microsoft SQL Server 2012 - http://technet.microsoft.com/en-us/library/ms188396%28v=sql.110%29

Ensure that all Indexes are covered by a weekly maintenance job to rebuild the indexes.

1 2 ... 68 69 70 71 72 73 74 75 76 77 78 79 80

Pas de commentaire

Dell Data Protection | Encryption Manuel d'utilisateur Page 73