Activity monitor, Script to find Head blocker- SQL Server 2005, 2008 and later
This is very handy useful script in production environment. Even the activity monitor does the same but when there is
–DB Blog
This is very handy useful script in production environment. Even the activity monitor does the same but when there is