You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “Blocking Processes (lead blocker)”.
Random MVP RSS Feeds- [SQLTeam] How to import in BIDS more than one SSIS package in one shot!: Have you ever wanted to add more than o... http://t.co/ZfC9u8I1
- Avoiding IF.. ELSE by using WHERE EXISTS - When coming from a programming... http://t.co/QdT0Ebyq #fb
- Avoiding IF.. ELSE by using WHERE EXISTS - When coming from a programming... http://t.co/QdT0Ebyq #fb
- DROP INDEX SYNTAX - Here is the syntax needed in o... http://t.co/ElqNyG3e #fb
- SET TRANSACTION ISOLATION LEVEL - This statement is used to set... http://t.co/0zGtNE1X #fb
- [Aaron Bertrand] Bad Habits to Kick : Thinking a WHILE loop isn't a CURSOR: I see a lot of people suggest while ... http://t.co/oDLn0pVs
- [Simon Sabin] Ten reasons to attend SQLBits X: If you are contemplating attending then I hope the following will... http://t.co/Zg6uqojD
- [Simon Sabin] SQLBits x an awesome line up –1100 people have already registered: I was really happy to have put ... http://t.co/zQu3m5ix
- [Aaron Bertrand] SQL Server 2012 : The "Launch Date" is not what you think it is: I see a lot of people getting ... http://t.co/i87shAFB
- [Aaron Bertrand] Bad Habits to Kick : Using AS instead of = for column aliases: This one is quite subjective, an... http://t.co/5uzyQWCv
-
Derek Dieter
Site Author Connect
shouldn’t the query be changed from
“WHERE spid IN (SELECT blocked FROM master.dbo.sysprocesses)
AND blocked = 0″
to
“WHERE spid IN (SELECT spid FROM master.dbo.sysprocesses)
AND blocked != 0″
?
This is Kalen Delaney’s code.
You might want to give her the credit.
Calif DBA
Tom,
Thank you. I definitely would have had I known it was hers. Thing is, I found it in a training manual passed out to me in a class from Microsoft and found it was very efficient.
There are certain DMV queries that I don’t know the originator of but in case she is the originator of any other queries, as you mention, I owe her a thanks so I will link to her site from my resources page.
As an additional thanks I’d also like to mention that if anyone has not read any of her internals books, I highly recommend them as they have been completely essential to at least my own understanding of SQL Server.
Kalen Delaney – SQL Server Internals