Blocking

Technical Article

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

Technical Article

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,184 reads

Blogs

Daily Coping 3 Feb 2023

By

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Read the latest Blogs

Forums

Re-creating AG after server loss

By izinger

We recently had to rebuild servers that were configured with AG. I built everything...

Cannot run DynamicSQL Statement to merge table with JSON

By Weegee71

Hi there I have a problem with a dynamicSQL Statement. In this code, I...

find connection details for all ssis jobs

By Bhagat

Hi, is there are way using sql that brings a list of the ssis...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers