SQL Server Performance Tuning Checklist

Sponosored by: Quest

Overview

This 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 checklist are:

  • CPU
  • Memory
  • Disks
  • Indexing
  • Maintenance
  • Query Plans
  • Query Optimization

Download your copy now!



Format: ZIP

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.

download


get free sql tips
agree to terms