Eliminate SQL Server deadlocks

SQL Deadlock Detector provides all information needed to get to the root cause of SQL Server deadlocks, in order to resolve and prevent them from occurring in the future.

Identify long running SQL Server locks

Examine detailed information about all long running locks, including the exact T-SQL lines executed and the specific SQL objects that were involved in SQL Server deadlocks and long running SQL Server locks.

Trace locks and SQL Server deadlocks down to code level

Trace SQL server locks and SQL server deadlocks down to code level. For each deadlock and lock, see the exact procedure and code line within that procedure that triggered each event.

Actual code is highlighted when locks and deadlocks occur

When viewing SQL Server deadlock or SQL Server lock details, the actual executed statement is highlighted within the context of the calling procedure or the T-SQL batch.

Uncover the precise duration of each lock down to the nearest millisecond

For each SQL Server lock and sql server deadlock, SQL Deadlock Detector provides precise duration information with millisecond accuracy.

Visually filter historical records for all SQL Server locks and SQL Server deadlocks

Use sophisticated visual filters to narrow down locks to those corresponding to specific calling applications, lock commands or database users in order to get to the root cause of SQL Server deadlocks and SQL Server locks.

Visualize and graph all sql server locks and deadlocks

SQL Deadlock Detector visualizes SQL Server lock and SQL Server deadlock graphs, showing all dependencies for each SQL lock event, regardless of its complexity.

Monitor 1-500 servers from a single console

SQL Deadlock Detector has been designed with the most demanding production environments in mind. Use this tool to monitor and view information from hundreds of servers from a single SQL Deadlock Detector console.

Uncover blocking SQL code and SQL Server deadlock victims with accuracy

SQL Deadlock Detector captures 100% of all sql server deadlocks and SQL Server locks meeting predefined wait time thresholds.

Get warned about locking issues before they become major problems

SQL Deadlock Detector dispatches alerts within seconds of a SQL Server deadlock or lock event. Configure profiles for users to receive selected alerts, all delivered via email or SMS.

Speed up your SQL Server application by minimizing long running locks

SQL Server performance can be dramatically slowed down as a result of blocking that often occurs between processes. Use SQL Deadlock Detector to reduce the number of long running SQL Server locks and increase the end user response time of specific database applications.

Isolate common patterns that contribute to SQL Server locks

SQL Deadlock Detector employs a sophisticated T- SQL parsing engine to aggregate historical lock and deadlock information, providing the capability to reveal commonalities and to uncover specific patterns that resulted in the greatest number of long running SQL locks and SQL deadlocks.

Aggregate historical info for locks and deadlocks

Historical information for SQL Server locks and SQL Server deadlocks can be used to baseline database application performance from week to week and from month to month. SQL Deadlock Detector provides historical trend reporting across dimensions such as number of locks per day, average lock duration per day or aggregate lock duration to date.

No impact on production performance

SQL Deadlock Detector captures all locking events asynchronously so that there is no impact on production performance. The tool is used in the most demanding, high throughput enterprise environments.