Thanks to everyone who turned up on Friday for the SQL performance tuning class. I hope that everyone got something out of it and I don;t get blamed for any mad experimenting on production servers now
Do watch the Prodata events page. We may have a new set of MasterClasses starting in Oct and even if you can’t make it up to Dublin, we can put a case in for having them in Galway as well if we can get enough numbers.
We showed some example of DMV queries to help with performance:
– Top x queries
– Interrogate the Plan Cache
– Show Virtual IO stats
Here is a link to the “DMV All Stars” file that Jimmy May has lovingly made up
http://blogs.msdn.com/b/jimmymay/archive/2008/10/31/drum-roll-please-the-debut-of-the-sql-dmv-all-stars-dream-team.aspx
Here is a link to the PowerPoint deck.Performance Tuning Deck
Hint: the password is the name of the company the event was at.