Learning Guide: SQL Server performance tuning A to Z

From testing and monitoring to tuning and troubleshooting, you're sure to find a tip or tool to help you resolve your SQL Server performance dilemmas in this guide.

To ensure your SQL Server databases and applications run at their full potential, you must continually monitor...

and identify performance problems and quickly address bottlenecks. This guide will help you do all that and more. It covers everything SQL Server performance, from the very best to the very worst practices and performance-tuning myths. If you'd like to see a specific topic covered regarding SQL Server performance, send us an e-mail or ask expert Jeremy Kadlec for help.

Monitoring & testing

Tuning & optimizing


  • Step-by-Step Guide: Hunt down SQL Server performance problems
  • SQL Server Clinic: T-SQL performance problems and solutions
  • SQL Server Clinic: Stop locking and blocking
  • Tip: SQL Server performance-tuning worst practices
  • Webcast: SQL Server performance-tuning myths
  • Expert response: Sluggish SQL Server 2000
  • Expert response: Long delay when application runs a query
  • Expert response: How to speed up a composite nonclustered index-based query
  • Expert response: Run sp_updatestats to recover performance
  • Expert response: Improve SQL Server performance by creating a transaction log file
  • Expert response: SQL Server 2000 jobs running for days



  • Tip: Why cluster
  • Tip: Setting up SQL Server clusters on a SAN
  • Expert response: Cluster index vs. non-cluster index
  • Expert response: How does failover clustering work in SQL Server 2005?
  • Expert response: Active/active vs. active/passive clustering


Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning