More Tom Davidson Magic

If you ever downloaded these two SQL 2000 documents, and I can’t find the links to them any more, you’ll know how great Tom Davidson’s white paper on waits and queues is and how it is the standard reference for what all those waits that you find in sysprocesses.

 

KB702_SQL Performance Tuning using Waits and Queues

and

KB703_SQL Server 2000 P&T Survival Guide.doc

 

Have been two of my staple references, and I adapted these for my own use, I thought I’d blogged the changes I did but I guess perhaps I didn’t in the end, I wanted a better way to store captured information for historical analysis. If anyone’s interested in the sql 2000 stuff then drop me a mail and I’ll forward it to them, there’s a lot of images in my documents so maybe that’s one of the reasons I didn’t blog it as adding the images to a post is a bit time consuming.

 

Well Tom has reworked his magic on SQL 2005 – I’m sort of hoping some of this will make its way into the performance dashboard in SQL 2008.

 

 

http://blogs.msdn.com/sqlcat/archive/2007/07/13/performance-analysis-tool-dmvstats.aspx

 

Published 16 July 2007 13:47 by GrumpyOldDBA

Comments

# re: More Tom Davidson Magic

19 July 2007 00:44 by sthornburg

I remember reading quite a bit about these methods (SQL Server Magazine comes to mind), and I would like to get the SQL 2000 items you referenced.  How can I best contact you with my email?

# re: More Tom Davidson Magic

19 July 2007 12:26 by GrumpyOldDBA

decipher the address colin[at]kelemconsulting[dot]co[dot]uk