Using SHERLOCK to Monitor Blocking
By Bill Graziano
on 2 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.