MSSQL Blocks


Version: 1.7.17.93
Size:
1010KB
Requirements:
No special requirements
Price:
Free
System:
Windows 2003/XP/2000/98/Me/NT
Rating:
4.5
License:
Freeware

Description - MSSQL Blocks



This utility has been developed for collecting information on blocking/blocked Processes (sessions) from multiple SQL Server 2000/2005 instances and presenting it in user-friendly format. The History behind creation of this utility is that we have our (translator: in-house developed) application which is running on several SQL instances and intermittently hangs (translator: due to blocks). To save us time of manually checking though all instances for possible long-running blocks I wrote this small program. It works through ADO in asynchronous mode. During refresh it fetches data from [sysprocesses] (system table) and transforms them into tree-like structure allowing to show only processes(sessions) in trouble. Now I can easily locate a problem just by running it. Being overjoyed by that I decided to Share IT

MSSQL Blocks Processes Sessions Mssql Blocks


More in Databases-MSSQL Blocks

Sessions Translator Processes Sessions Wrote This Small