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

Blogs

Goal Progress for June 2022

By

I set goals at the beginning of the year, and I’m tracking my progress...

Using Sessionize for Your User Group – Part 2

By

Now that your CFS has been setup it’s time to get the word out...

Daily Coping 1 Jul 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Identify Process

By jsshivalik

Hi Is it possible thru query or other means which sql process are running...

Invalid column name when fetching large amounts of data

By Tibor_Sebok

Hi Guys, I am developing an SSIS package right now where I have to...

Christmas in July

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Christmas in July

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers