Project Description

The SQL Server Blocked Process Monitor makes monitoring, tracking and troubleshooting blocking inside SQL Server 2005 and SQL Server 2008 easy. You'll no longer have to manually enable and run a trace to capture the blocked process report. It is developed in C#.

Features

Console Application that can be run to setup and capture blocked process reports from SQL Server 2005 and 2008. In addition to capturing the blocked process reports, the application will parse the Report XML and use the sqlhandle information contained in the report to capture the actual sqltext from the sys.dmexecsql_text DMV as the blocking occurs. Output is made to a standard XML document for future review.

There are 2 versions of the application, one targeted at SQL Server 2008, and one targeted at SQL Server 2005. This was required since the .NET framework versions are different, and the SMO Assemblies are different between the two editions, and unless .NET 3.5 SP1 and the SQL Server 2008 SMO assemblies are installed on a SQL Server 2005 server, the application won't run as originally intended.

Usage

sqlbpm
[-S server] Specify the SQL Server and Instance to connect to.
[-E trusted connection] Specify to use Integrated Security.
[-U login id] UserName to authenticate with.
[-P password] Password for the specified Username.
[-O outputfile] The name of the Output file to be created.
[-T templatefile] The name and path of the template file to use.
[-? show syntax summary] Displays this help information.

Updates and Additions

If you have an idea for an update or addition that will make the application more usable, please lock a Issue in the Issue Tracker or open a Discussion Item and it will be considered for a future version of the application.

Last edited Apr 28, 2009 at 7:20 PM by jmkehayias, version 5