Using Extended Events to Find Blocks in SQL Server 2012

As a ConfigMgr admin there are times when it may be necessary to determine why SCCM is responding more slowly than normal.  One possibility when conducting this analysis is a slowdown on SQL Server itself.  In this article, I’ll talk briefly about one reason SQL might become non-responsive and how to identify what’s going on….