Оптимизация производительности SQL Server

Некоторые методики поиска и устранения проблем с производительностью:

(c-sharpcorner.com) SQL Query Performance Tuning

(technet.microsoft.com) Troubleshooting Performance Problems in SQL Server 2005

(sqlblog.com) How To Get High Quality Information About Query Performance

(technet.microsoft.com) Performance Tuning Waits Queues.doc

(simple-talk.com) Troubleshooting with Dynamic Management Views

(blogs.msdn.com/b/ahmedir) SQL Server Health Check, Physical disk I/O operations, BizTalk Server design and settings

(technet.microsoft.com) Appendix A: Monitoring SQL Server health


(technet.microsoft.com) Top SQL Server 2005 Performance Issues for OLTP Applications


(sqlserverinternals.com) Methodology

(codecapers.com) SQL Performance Tuning Basics


Useful T-SQL queries for a SQL Server 2008 administrator

Tips & Tricks for optimizing the performance of your SQL Server

SQL Server: 4-Step Performance Troubleshooting Methodology--Introduction

Курс по оптимизации производительности (Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 Course 2790A)