Our speaker this month is Jason Strate. Jason will be presenting “Discovering the Plan Cache”.
Topic Abstract:
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.
Speaker:
Jason Strate, Digineer Inc, is a DBA with over fifteen years of experience. He is a recipient of the Microsoft Most Valuable Professional (MVP) for SQL Server since July, 2009. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Certification exams for SQL Server 2008.
This meeting is sponsored by CONFIO SOFTWARE. There will be a drawing for a $50 Amazon gift card at the end of the meeting. A winner will be randomly chosen from all those in attendance for the whole webcast who provide their email address.
Meeting Details:
January 26th, 4PM EST
Performance Virtual Chapter on the web!
Website – http://performance.sqlpass.org
Twitter – http://www.twitter.com/SQLPass_PVC
Distribution List - http://groups.google.com/group/perfvc
Ryan J. Adams
NTSSUG Director of Logistics and Communications
PASS Performance Virtual Chapter Director of Marketing
PASS Regional Mentor – U.S. South Central
MCP MCSA MCSE MCDBA
MCTS:SQL 2005 MCITP:SQL 2005