Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Complete Blocking Report Expand / Collapse
Author
Message
Posted Thursday, January 1, 2009 4:27 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, October 7, 2013 9:29 AM
Points: 409, Visits: 421
Comments posted to this topic are about the item Complete Blocking Report
Post #628399
Posted Thursday, January 8, 2009 2:50 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, March 3, 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
Posted Thursday, January 8, 2009 3:44 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:15 AM
Points: 891, Visits: 1,553
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,

Just say No to Facebook!
Post #632943
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse