September 21, 2015 at 6:47 am
Hi,
There are severeal spids blocking from sp_who2 and sys.sysprocess but how do we know head blocker spid and what it is doing?
September 21, 2015 at 6:56 am
Why are you still using sysprocesses? It's the SQL 2000 function, it doesn't show any newer properties or columns
The head will be the one which is referenced by other sessions in the Blocked_by, but is itself not blocked. You see what it's doing by cross applying to sys.dm_exec_sql_text (not possible if you insist on using sysprocesses
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply