About Performance and Tuning in SQL Server (SSQA)

There are many issues that affect SQL Server performance and scalability. This website discusses these issues, starting with data design and ending with deployment. The blog emphasizes the techniques you can use to obtain the biggest gains in performance and scalability.

The sample scripts that are listed under this website must be tested on your platform. The sample scripts are provided AS IS without warranty of any kind. The entire risk arising out of the use or performance of the sample scripts and documentation remains with you.

In no event shall SSQA, its authors, or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample scripts or documentation.

Performand and Tuning includes:

• Design efficient schemas.
• Optimize queries.
• Fine-tune indexes.
• Perform efficient transactions.
• Build efficient stored procedures.
• Analyze and understand execution plans.
• Identify and eliminate execution plan recompiles.
• Avoid scalability pitfalls when you use SQL XML.
• Tune Microsoft SQL Server.
• Test and monitor your data access performance.
• Consider how deployment decisions impact performance and scalability.

For further comments and content you would like to provide email sqlmaster@sqlserver-qa.net.