Sponsored by: MSSQLTips
Overview
This SQL Server Performance Tuning Checklist, written by MSSQLTips author Eric Blinn, will serve as a starting point to help determine what steps might make sense as part of a SQL Server performance improvement effort. It provides information for each checklist item and links to other articles for more details when applicable.
There are 2 main sections. The first section covers actions that might make sense when the entire SQL Server instance is running slow. The second section focuses on areas where specific queries or procedures are running slowly. A performance tuning effort often includes both parts.
Some of the items included in the SQL Server Performance Tuning checklist are:
- CPU
- Memory
- Disks
- Indexing
- Maintenance
- Query Plans
- Query Optimization
Download your copy now!
For 20+ years, MSSQLTips.com has been delivering comprehensive technical solutions on a daily basis for the Microsoft SQL Server platform. In that time, an innovative team of over 300 authors from around the globe have delivered over 7000 articles and 1000 webcasts ranging from beginner topics to advanced solutions. Our community prides itself on delivering human only generated content.
Great source for SQL server DBA