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

Troubleshooting

  • 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

Indexing

Clustering

  • 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

Tools

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

SearchBusinessAnalytics
SearchDataCenter
SearchDataManagement
SearchAWS
SearchOracle
SearchContentManagement
SearchWindowsServer
Close