Blocking Processes (lead blocker)

Posted on June 17, 2009 by Derek Dieter
8

SELECT
spid
,status
,loginame = SUBSTRING(loginame, 1, 12)
,hostname = SUBSTRING(hostname, 1, 12)
,blk = CONVERT(char(3), blocked)
,open_tran
,dbname = SUBSTRING(DB_NAME(dbid),1,10)
,cmd
,waittype
,waittime
,last_batch
FROM master.dbo.sysprocesses
WHERE spid IN (SELECT blocked FROM master.dbo.sysprocesses)
AND blocked = 0

Find Resource Currently Involved in Blocking

Posted on May 31, 2009 by Derek Dieter
No

[cc lang=”sql”] SELECT DISTINCT objname = object_name(p.object_id) FROM sys.partitions p JOIN sys.dm_tran_locks t1 ON p.hobt_id = t1.resource_associated_entity_id [/cc]

Site Author

Thanks for visiting!

Blocking Processes (lead blocker)

Find Resource Currently Involved in Blocking

Featured Articles

Site Author

Resources