Note that throughout this guide, we point to performance content for SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. Most of the guidance written for SQL Server 2005 applies to later versions of SQL Server – but if we point to
SQL Server 2005 content that doesn’t apply to later versions, (and vice versa) we’ll point it out.
This Performance Survival Guide is a continual work in progress, so please add your own performance tips and troubleshooting advice. Just click the "Edit" button above this article to add or improve the existing content.
Follow the links in this guide to learn about how to diagnose and troubleshoot SQL Server performance issues. We point to SQL Server performance related articles, tips & tricks, whitepapers, useful tools, social networking sites, and more!
Note that this guide focuses on SQL Server core engine performance and not the Business Intelligence technologies. For detailed information about Analysis Services performance, see the
SQL Server 2008 R2 Analysis Services Operations Guide and the
Analysis Services 2008 R2 Performance Guide. Additionally, the following links contain some excellent articles written by the SQLCAT team to help you troubleshoot your Integration and Analysis Services performance issues.
Online transaction processing (OLTP), workloads are characterized by high volumes of similar small transactions. You need to keep this in mind when you are trying to troubleshoot resource utilization and system performance. The following resources provide
performance information for OLTP applications:
Data warehouses are characterized by queries that scan larger numbers of rows, large ranges of data and may return relatively large results for the purposes of analysis and reporting. Most relational technologies are not tuned to deal with the large-query
and data-loading workloads of data warehousing. The following links provide some general information and best practices about how to make the data base engine work more efficiently.
Following are some links to help you get the most out of SQL Server and your hardware:
This section lists the publicly available tools you can use to diagnose and troubleshoot SQL Server 2012 performance problems in common customer scenarios.
This section contains some useful links to articles that contain tips and tricks that you can use to help improve your SQL Server performance. Everyone likes tips and tricks, so please add your own by clicking the "Edit" button above this article!
Note that the following are not Microsoft articles and the opinions and views expressed are those of the author and do not necessarily state or reflect those of Microsoft.
For a more general set of SQL Server documentation that includes information about monitoring and managing database engine performance, see the following topics in SQL Server Books Online.
The Web contains a rich set of advice and guidance for troubleshooting performance - from learning the basics, to the hard to find corners most people don't go to. Here are what the community thinks are the best:
The SQL Server Customer Advisory Team (SQLCAT) team manages all customer activity out of the SQL Server engineering organization and engages with the most interesting SQL Server customer projects across the
There are a number of blogs that contain a log of great information about troubleshooting SQL Server performance. Following are some blogs you might want to check out.
Note that the opinions and views expressed in non-Microsoft blogs are those of the author and do not necessarily state or reflect those of Microsoft.
Microsoft Corporation Blogs
Do you have a SQL Server question that needs answering? Forums are an excellent place to ask questions and find answers to your SQL Server performance issues.
SQL Server 2008 Forums
SQL Server 2005 Forums
The SQL Server Resource Centers connect users to the help content, how-to information, downloads, installation information, community, social media, and other online resources that help you deploy, maintain, and support SQL Server.
To learn useful, practical techniques to help you improve your SQL server performance skills, you can register for the following performance workshops, or download copies of the workshop videos.
You can tweet with some of the best minds in the SQL Server community. Following are some of the active Microsoft SQL Server employees on Twitter. For a more comprehensive list of tweeters in the Microsoft SQL Server community, see
SQLServerPedia, a community knowledge base.
Congratulations on the article being featured on the home page of TechNet Wiki!
Cleaned up the TOC. This could use some header cleanup as well. Maybe later. =^)
Excellent article. It will be really helpful to those who wants to upgrade to SQL 2012. Including myself
Great article. Amazingly thorough.
Now THAT's a Survival Guide!!! Great job, Jamie! Definitely nominating this one to be featured.