SQL Block Monitor is an historical and real-time blocking monitor tool for Microsoft SQL Server.
SQL Block Monitor 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.
Supported Database:
· SQL Server 2005
· SQL Server 2005 Express
· SQL Server 2000
· MSDE 2000
Here are some key features of "DMT SQL Block Monitor":
· Real-time SQL Server block detection and alerting.
· Creates live blocked process list of SPIDs being blocked, SQL involved in blocking, where locks are occurring and more.
· Reconstruct the complete blocking events over time.
· Rank SQL statements and host most frequently involved in blocking, causing the worst end user response times, using the most CPU, memory and I/O resources.
Requirements:
· Intel or compatible Pentium 166 MHz or higher recommended
· 128 MB RAM or more
· 5MB of available HD space for program installation
Limitations:
· 14 days trial
· Nag screen