Blocking in a SQL Server can have serious consequences if not addressed promptly. If left unchecked, blocking can cause a backlog of queries that can eventually lead to the server becoming unresponsive or even crashing. To avoid this, it’s important to monitor for blocking and take action as soon as it occurs. One way to do this is by setting …

Unresponsive or Crashing Server? Read more »

SQL Server Blocking queries are one of those things that can really bog down your database. You might have plenty of memory, and way more CPU than you need, but a single blocking query may bring your server to a halt. Over the last several years at Stedman Solutions we have done lots of performance tuning assessments, and when we …

SQL Server Blocking Query Monitor + Mentoring Read more »