SQL Block Monitor is a blocking and deadlocks monitor tool for Microsoft SQL Server. Product empowers users with a historical blocked events of every unique individual piece of SQL involved in blocking. Enables you to know exactly what SQL is causing the blocked process phenomena. Identified SQL is ranked on a top down recourse basis showing organizations what blocked process SQL is running the longest on the database server and utilizing the most resources.

Feature

Real-time SQL Server blocking and deadlocks detection and alerting.
Creates live blocked process list of SPIDs being blocked, SQL involved in blocking, where locks are occurring and more.
Captures for the blocking SPID and all blocked SPIDs the SQL statement text, SQL statement show plan, resource usage, and locks held.
Report SQL statements, host and program most frequently involved in blocking, causing the worst end user response times, using the most CPU, memory and I/O resources.
Low-impact monitoring and no installation of components on your SQL Servers.

SQL Serverв„ў support

SQL Server 2008
SQL Server 2008 Express
SQL Server 2005
SQL Server 2005 Express
SQL Server 2000
MSDE 2000

Home:

http://www.sql-tools.net/blockmonitor/

Only for V.I.P