Experts' Perspective Webcast: Discovering the Plan Cache

This webcast was originally presented on Thursday, August 11
Duration: 1 hour
Cost: Free

Looking for simple ways to improve your queries and SQL Server performance? Be sure to catch this insight-packed session with Jason Strate, SQL Server MVP. Jason will explore fast and easy ways to achieve unprecedented performance using the plan cache, which is where execution plans are stored. This metadata can provide insight into how your SQL Server environment is functioning. By using XQuery, Jason will show you how to search the plan cache to find potential performance issues and opportunities to tune your queries.

You’ll learn how to use this information to:

• Reduce issues related to parallelism
• Shift queries from using scans to using seek operations
• Discover which queries are using what indexes

All of this and more is readily available through the plan cache. So don’t miss this opportunity to get started on the road to discovery. 

Before the end of this session, you’ll have new scripts you can run the same day. (The session also follows Jason’s “MVP Deep Dives II” chapter.)

Hosted By: Kevin Kline, SQL Server MVP and Technology Strategist for Quest Software
Featuring Special Guest Presenter: Jason Strate, SQL Server MVP