How to Identify Blocking Problems with SQL Profiler
Posted by: Simple Talk,
on 13 Mar 2009 |
View original | Bookmarked: 0 time(s)
Many SQL Server developers and DBAs have, in the past, had their own favourite diagnostic Stored Procedures for investigating blocking issues, but since SQL Server 2005, it is a good idea to use the SQL Profiler for all but the most complex problems. This has a blocked process report which can tell you what the problem is, and give a good indication as to how to correct it....