5 Comments

1. Anonymous says:

   April 15, 2012 at 3:19 am

   I have pasted this and run. it shows 0 rows affected. Please help

   Reply to this comment
2. John P says:

   February 22, 2012 at 8:17 am

   Absolutely love the code you have published! Thanks so much. Below is one change I made so that I could see the wait type description vs. the wait type code. Thanks again.

   changed this:
   ,waittype
   to this:
   ,er.wait_type

   Reply to this comment
3. Al says:

   October 26, 2011 at 6:35 pm

   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″

   ?

   Reply to this comment
4. Tom says:

   May 26, 2010 at 1:26 pm

   This is Kalen Delaney’s code.
   You might want to give her the credit.

   Calif DBA

   Reply to this comment
   • Derek Dieter says:

     May 26, 2010 at 1:56 pm

     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

     Reply to this comment