New Tools for Troubleshooting Concurrency

SQL Server 2005 adds some important new tools for troubleshooting concurrency issues. It still includes legacy tools such as system stored procedures like sp_who2, Perfmon counters, and the SQL Trace/Profiler tool for troubleshooting concurrency problems, but expands your toolkit even further.

For detection and analysis of concurrency problems, SQL Server 2005’s new tools include:

  • DMVs, in particular sys.dm_os_wait_stats and sys.dm_os_waiting_tasks.

  • The enhanced SQLDiag.exe utility, which gathers information about a running system.

  • Row-versioning–based isolation options (the SNAPSHOT and READ COMMITTED SNAPSHOT isolation levels)

  • The new 1222 trace flag and the Deadlock Graph event class in SQL Trace for ...

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.

Start your free trial