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

Blogs

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

By

Welcome back to my series on Power Platform quick tips! In this episode you...

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Read the latest Blogs

Forums

Tracking History in Fact Table

By Niggles

Hi, I was hoping somebody would be able to offer advice in relation to...

How to get information about an AG group using powershell

By vsamantha35

Hi Experts, Does anyone has a powershell script which displays below information: for a...

Find out who stopped my SQL Services

By vsamantha35

Hi Experts, Is there a way to find out which windows user has stopped...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers