SQL Centre of Excellence

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 Winking smile

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.

Hint: the password is the name of the company the event was at.

Page List

Page List