9. Blocking and Deadlock Analysis

Blocking
SQL Sentry Performance Advisor's hierarchical display of all blocking chains provides the most complete picture of blocks available. Wait Resources are automatically resolved for you, so for the first time you can instantly see which tables or indexes are being contended for without any manual effort!

Deadlocks
Unlike other deadlock graphing tools, deadlock nodes in Performance Advisor contain the concise information you need to quickly visualize the deadlock and determine the root cause. You get a graphical display of all deadlock types, synchronized with an innovative grid-based display to provide the most complete picture of SQL Server deadlocks available.

The grid display lists all nodes organized by resource, owners and waiters, and includes the full SQL for all nodes!

"Performance Advisor has quickly become our main tool for identifying current and potential problems. Diagnostic analysis and reporting tasks that previously required numerous tools and lengthy steps have been consolidated into a single, indispensible part of our toolbox."
-- Denis McDowell, Senior Systems Engineer, Peak 10 Inc.