http://www.sqlservercentral.com/blogs/stratesql/2012/01/04/pass-summit-evals-plan-cache-querying/

Printed 2014/07/30 07:52AM

PASS Summit Evals – Plan Cache Querying

2012/01/04

This past year, I spoke at the PASS Summit for the second time. The first time was a couple years ago and it was not the best presentation that I had ever given.  This year, though, things went a little bit differently.

Originally, I was slotted for a single session, but after someone dropped out was offered the opportunity to speak at a second session. Over the next two blog posts, I’m going to share the evaluations that I received from the event. They definitely sucked less than the first time I spoke at PASS.

My first session at the summit was Discovering the Plan Cache:

Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery.

Overall Ratings

From a high level, the ratings are pretty good.  All were above 4’s and seem to convey that I have an idea of what I am doing.  Unfortunately, the rating scale doesn’t help me understand what I need to change to go from 4’s to 5’s.

How would you rate the Speaker’s presentation skills? 4.36
How would you rate the Speaker’s knowledge of the subject? 4.71
How would you rate the accuracy of the session title, description and experience level to the actual session? 4.75
How would you rate the quality of the presentation materials? 4.54
Did you learn what you expected to learn? 4.46

Commentary

Fortunately, people left comments.  I like comments – they can be related to and I thank everyone that left them.

Did you learn what you expected to learn?

How would you rate the accuracy of the session title, description and experience level to the actual session?

What will you take away from this session?

What would you change to improve the overall quality of this session

Summary

I’m glad so many people found the session interesting and informative.  Querying the plan cache can be a lot of fun and a good way to scale up your tuning practices.  If you watch the video on the Summit DVDs, let me know what you think.  Thanks again to every one that attended.

Related posts:

  1. PASS Summit 2011 Session Materials
  2. PASS Summit Submissions Complete
  3. Speaking At The PASS Summit


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.