Troubleshooting SQL Blocking Scenarios with Activity Monitor

A demonstration on how to troubleshoot a SQL Server blocking scenario with just Activity Monitor.

Read this article...

Amit Banerjee

Amit currently works as a Premier Field Engineer at Microsoft specializing in proactive and advisory assistance for SQL Server environments.

In the past, Amit was part of the SQL Server Escalation Services team at Microsoft. His day-to-day work involves fixing and troubleshooting complex issues related to SQL Server over a varied range of environments, which could be a deployment handling just 100 users or 10 million users.

Over the years, he has learned various ways of slicing and dicing diagnostic data collected for troubleshooting and picked up a few tricks & tid-bits about the internals of this ever-evolving product called SQL Server.

For more information about Amit, visit his blog at

comments powered by Disqus