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.
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|
Fortunately, people left comments. I like comments – they can be related to and I thank everyone that left them.
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.