Complete Blocking Report

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Veeresh V Nashi » Complete Blocking Report

Complete Blocking Report

Rate Topic

Display Mode

Topic Options

Author

Message

Vee

Posted Thursday, January 01, 2009 4:27 AM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 5:17 AM
Points: 409, Visits: 409

Comments posted to this topic are about the item Complete Blocking Report

Post #628399

dave.morrow-584993

Posted Thursday, January 08, 2009 2:50 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, March 03, 2010 10:34 AM
Points: 79, Visits: 32

I've been using the following which provides similiar information.

ALTER proc [dbo].[sp_blocking]
as
declare @spid int

select @spid=sy1.spid
from master.dbo.sysprocesses sy1(nolock)
join master.dbo.sysprocesses sy2(nolock) on sy1.blocked=sy2.spid and sy2.blocked=0
where sy1.blocked!=0

SELECT
sy1.spid,
sy1.status,
sy1.hostname,
sy1.program_name,
sy1.cmd,
sy1.blocked,
sy1.dbid,
convert(sysname, rtrim(sy1.loginame)) as loginname
from master.dbo.sysprocesses sy1(nolock)
where sy1.spid=@spid

dbcc inputbuffer(@spid)

Post #632199

YSLGuru

Posted Thursday, January 08, 2009 3:44 PM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 11:18 AM
Points: 848, Visits: 1,453

Is anyone else having problems getting to the page with the actual script/code? No matter how I try to navigate to it, everytime I get the 'Need to Register' page/pop-up and clicking the 'Log In' button just refreshes the page.

Thanks

Kindest Regards,

A Democracy works great until the day you find yourself on the sheep side of a vote between 5 wolves and 4 sheep on what’s for dinner when neither have eaten in many days. A free Republic where the rights of the few and the individual are protected is the only one in which Freedom and Prosperity for all have a chance to blossom.

Post #632943

« Prev Topic | Next Topic »

Permissions