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.

You rated this post out of 5. Change rating

2013-06-07

3,144 reads

Blogs

How Long Will It Take to Learn SQL? The Truth Might Surprise You

By

In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...

Flying Halfway Around the World to Australia

By

I leave tonight for Australia. I was in London 3 days ago, so this...

Dealing with Change – Two Resources

By

As I look at the state of information technology today, I see one constant:...

Read the latest Blogs

Forums

Reference for doing Data Warehousing in SQL Server

By pietlinden

Everybody (well almost) knows that if you want to learn the design patterns for...

SSIS Execution Error

By Wecks

I am no SSIS expert and am struggling here I am hoping some of...

Pivot query

By Roust_m

Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...

Visit the forum

Question of the Day

Using Table Hints in a Query

How many table hints can I include in a query?  

See possible answers