dmt sql block monitor is a real-time and historical blocking monitor tools 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. features: * 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. * captures for the blocking spid and all blocked spids the sql statement text, sql statement show plan, resource usage, and locks held. * reconstruct the complete blocking incident with all spids sql statement text and sql statement show plan. * 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.