Course 2790: Resources on blocking
As a followup to a question in this week's 2790: Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005 session, here are some additional resources on using SQL Server tools to monitor blocking:
- Knowledgebase article Q271509 How to monitor blocking in SQL Server 2005 and in SQL Server 2000
- Adapting SQLDiag to invoke sp_blocker_pss_80 (and some other interesting ideas)
- Top SQL Server 2005 Performance Issues for OLTP Applications SQLCAT - Top 10 Lists
- SQL Server Wait Types, Perfmon Counters, and Correlations




Reader Comments