Eric Wahner

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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2007-04-19 (first published: 2007-03-20)

7,468 reads

Discuss

What's Running

by Eric Wahner

SQLServerCentral

Lock and Connection Management

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. […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-04-17 (first published: 2007-03-20)

2,765 reads

Discuss

All authors

Eric Wahner

Dynamic PIVOT CLR

Procedure Class Generator

Space Used By Table

Who's Blocking

What's Running

Blogs

Five Ways Redshift Serverless Quietly Eats Your Budget

A Career of Memories

Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead

Forums

Alamat kantor BCA KCP Ketanggungan Timur Telp:0818751777

Alamat kantor BCA KCP Slawi Telp:0818751777

Alamat kantor BCA KCP Ketapang Telp:0818751777

Question of the Day

BCP on Linux