Galway SQL Master Class–Performance Tuning

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

Here is a link to the  PowerPoint deck.Performance Tuning Deck

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

Leave a Reply