Technical Article

Script to kill the top blocker and report what it was doing.

This script identifies the blocking locks at the top of the blocking chain and kills them. Specifically, it reports what the top blocking spids are doing, kills them, waits three seconds and then reports on current blocking status.  If you have a situation where single connections are causing a huge blocking chain and you want […]

4.75 (4)

2003-05-12

2,742 reads

Blogs

Azure Cosmos DB – HTAP using Azure Synapse Link

By

I haven’t done much blogging in the last 6 months. My last article was...

Azure Cosmos DB – HTAP using Synapse Analytics

By

I haven’t done much blogging in the last 6 months. My last article was...

Power BI Meets Programmability – TOM, XMLA, and C#

By

For anyone who read the title of this and immediately thought, “Oh no, I...

Read the latest Blogs

Forums

AlwaysON on one Node

By Arsh

Hi friends, Is it possible to configure ALwaysON with two instances on one node...

SQL Server Single Instance FCI - Failover Error

By Shivkumar

I have the following setup. 3 Node WSFC Cluster hosted on EC2 in three...

Disabling all access to the server

By Alex John

Hello everyone! We have a small group of users (4) using MS Access 2000...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers