Tags: performance, SlowTV, SQL Server, tools, wait interface.
Well, the guess-days might be just about over for SQL Server DBA’s. People who revolutionized Oracle performance tuning several years ago, are now working at SQL Server revolution.
And here is Cary Millsap from the same event:
If you find a bit unusual how those interviews were done, check Cary Millsap’s blog (keyword - SlowTV).
If you look at the agenda of the Miracle SQL Server Open World 2008. You can see that Mario Broodbakker was one of the instructors of the “Stop Guessing” performance workshop. You might also know that about a year ago, Mario published couple very interesting articles.
Unfortunately, based on what I can conclude from Mario’s articles, SQL Server 2005 wait interface is implemented only on global database level and session level collection can only be achieved by a hack. I’m a bit disappointed that www.sqlinternals.com doesn’t seem to reflect an original content anymore (though it’s useful if you live in Old While Hill Stuarts Draft, VA). I would think that it could also be implemented with some debuggers but it probably not for production use either.
Anyway, it’s a good start and it seems that it’s only the beginning. Keep an eye on those guys!Find more about performance SlowTV SQL Server tools wait interface