Using SHERLOCK to Monitor Blocking

By Bill Graziano on 02 August 2005 | 20 Comments | Tags: Administration

I recently received an email from Roberto Farah who works at Microsoft's PSS. Roberto is the co-author of a tool called Sherlock that helps analyze blocking problems in SQL Server. It pulls together the information from sp_blocker_pss80 and provides it in an easy to read format. The download includes the program and a short PowerPoint presentation explaining its use. I'll post additional information after I've had a chance to work more with it tomorrow. (This is a .NET application.) Thanks Roberto! UPDATE: The download has been updated to version 1.3 to fix a minor problem.

Discuss this article: 20 Comments so far. Print this Article. This page has been read 19,183 times.

If you like this article you can sign up for our newsletter. We send it out each week that we post a new article. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Email This • Subscribe to this feed • Kick it • Save to del.icio.us • View blog reactions

Using xp_ReadErrorLog in SQL Server 2005 (12 May 2008)

Moving the tempdb database (5 November 2007)

Centralized Asynchronous Auditing across Instances and Servers with Service Broker (20 August 2007)

Centralized Asynchronous Auditing with Service Broker (16 July 2007)

SQL Server 2005 Best Practices on TechNet (4 December 2006)

Scripting Database Objects using SMO (Updated) (29 November 2005)

Troubleshooting Performance Problems in SQL Server 2005 (3 November 2005)

Dynamic Management Views (30 October 2005)