Eric Wahner


Technical Article

Who's Blocking

A quick little standalone script that tells you what process is blocking and what processes the blocking processing actually blocking.When running this script in QA, change your output to "Results in Text" ( CTRL-T ).  Utilizes the blocking info in sp_who2 combined with dbcc inputbuffer and a little cursor to wrap it all up.  Formatting […]

2.33 (3)

2007-04-19 (first published: )

7,425 reads

Technical Article

What's Running

spWhatsRunning does just that.  It tells you exactly what is executing on your server.  By combining the output of the sp_who and dbcc inputbuffer, this script will tell you exactly whats being executed.  DBCC INPUTBUFFER will tell you the same thing, but by the time you get the spid, the offending process may be gone.  […]

2007-04-17 (first published: )

2,562 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