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

Blogs

Database DevOps Deployment to Azure–Webinar

By

You can register now, but on Dec 3, I have a webinar with Microsoft...

[PowerShell Newbie] Using Start-Transcript

By

This week we are going to launch a blog series geared towards folks that...

My Experience on Geeks on Screen with Coffee

By

Last week on appeared on Geeks on Screen with Coffee which broadcast on YouTube...

Read the latest Blogs

Forums

Finding Thanks

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding Thanks

Python Static Methods

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Python Static Methods

Query SSISDB For Components

By alex.sqldba

Evening All, I want to identify all SSIS packages deployed into SSISDB that contain...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers