Using SHERLOCK to Monitor Blocking

By Bill Graziano on 2 August 2005 | 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.

Related Articles

Advanced SQL Server 2008 Extended Events with Examples (25 May 2009)

Introduction to SQL Server 2008 Extended Events (19 May 2009)

Monitoring SQL Server Agent with Powershell (24 March 2009)

SQL Server Version (29 January 2009)

Scheduling Jobs in SQL Server Express - Part 2 (1 December 2008)

Alerts for when Login Failures Strike (14 July 2008)

Using xp_ReadErrorLog in SQL Server 2005 (12 May 2008)

Moving the tempdb database (5 November 2007)

Other Recent Forum Posts

I have a sql query which returns a sum of total amount by user and I am trying to add another column which uses the total and multiply it by a number (22h)

Troubleshooting Deadlocks in SQL Server (10d)

Last Login date and time (11d)

Negative effects of High VLF counts (11d)

Need to return a value that indicates that a record has been added, but not when a record is modified (12d)

Indexex on low cardinality fields (12d)

Error in stored procedure (13d)

Spam post flagging (13d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site