Summary
Troubleshooting concurrency issues in SQL Server 2005 primarily involves dealing with and resolving locking, blocking, and deadlocking issues. SQL Server 2005 provides you many new tools for detecting, analyzing, and resolving these issues. For detecting and resolving blocking, new dynamic management views allow you to monitor waiting tasks and discover the queries causing blocking. In addition, the new SQL Trace Blocked Process Report event class allows you to view blocking meeting a certain threshold and store the results for later analysis. For detecting and resolving deadlocks, SQL Server 2005 provides new deadlock reporting options with the 1222 trace flag and the SQL Trace Deadlock Graph event class. For reducing shared locking, ...
Get Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
