Blocking

New Custom Metric: Percentage of blocked connections

  • Article

This metric reports the number of connections that are currently blocked, divided by the total count of current connections.

Most well-balanced SQL Servers will have some degree of blocking. This metric attempts to measure the impact of lead blocking queries against other queries. Higher values indicate that many connections are being blocked, and queries should be tuned to reduce the amount of contention.

2013-06-07

3,144 reads

Complete Blocking Report

  • Script

A complete blocking report which gives the complete information about what queries are runninng and it will be worth capturing the details before we decide to kill the processes.

3 (6)

2009-01-08 (first published: )

2,160 reads

Blogs

A simple Machine Learning process example (supervised) – just to start with

By

I have just written the fifth article of the Machine Learning topic. !!! This...

Always On: Troubleshooting Consolidated

By

Working on Always On and configuration/setup of AG we have observed many errors. especially...

Changing Git Credentials in Windows

By

tl;dr For Windows when you need a different account. I had to work with...

Read the latest Blogs

Forums

SSRS page number by a certain column grouping

By Siten0308

Hello, I have been givin a task and not sure how to handle this,...

Best Work from Home training najafgarh

By ParminderSingh

Some work from home jobs require a bit of skill, experience, or credentials while...

SQL -> Oracle Linked Server DTC Error

By GonnaCatchIT

Dear Team, I am migrating from SQL 2008 to SQL 2014 for one of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers