We are down to the last few days before first SQL Saturday in Fargo. It’s been some work pulling it all together, but with the help of Ted Krueger (Blog | @Onpnt), Sarah Strate (Blog | @DanceM0m), and Jes Borland (Blog | @grrl_geek), we are almost ready for the weekend. The question I have for you is… are you registered? Of course, not everyone can make it, and many of you aren’t close enough to join us. For you folks, I ask, have you let your peers in Fargo, Moorhead, or West Fargo know about this event?
Its looking to be a great time with a great line up. The schedule is up, the sponsors are ready, and many of us are registered. Of course, there is room for a few more, so if you want to join us get registered now.
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.
If you are in the area and looking to enhance your career and expand your knowledge on SQL Server, you should take the day and join us to learn about SQL Server. The event is free and you can get registered here.