Saturday, May 02, 2009

SQL Tools : SQL Server Blocked Process Monitor Tool

I'm reading: SQL Tools : SQL Server Blocked Process Monitor ToolTweet this !

Welcome a new SQL Server tool on the block, "SQL Server Blocked Process Monitor". It's available on Codeplex. The project description as available on the tool's site is as below:

"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#."

Also one update that I got from Jonathan Kehayias blog is that it requires the following componets to execute. Below is an excerpt from his blog. A few of these components are the minimum requirements to install SQL Server 2008 itself. Honestly speaking this tool can be a collectible for DBAs, but being from the Data warehousing side, as of now I don't find much use of it for me. May be some DBA would like to review this one.

Excerpt:

If you want to test the application, you can do so if you have .NET 3.5 installed and you install the SQLCLR Types and SQL SMO features from the SQL Server 2008 Feature Pack: http://www.microsoft.com/downloads/details.aspx?FamilyId=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en

Windows Installer 4.5 Redistributable:

http://www.microsoft.com/downloads/details.aspx?familyid=5A58B56F-60B6-4412-95B9-54D056D6F9F4&displaylang=en

Microsoft .NET Framework 3.5 Service Pack 1 (Full Package)

http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe

Microsoft SQL Server System CLR Types x86:

http://go.microsoft.com/fwlink/?LinkId=123721&clcid=0x409

Microsoft SQL Server 2008 Management Objects x86:

http://go.microsoft.com/fwlink/?LinkId=123708&clcid=0x409

This project will be split into a version for SQL Server 2008, which is what exists today, and another version targeting .NET 2.0 and SQL Server 2005, which will be coded correctly in the next release.

No comments:

Related Posts with Thumbnails