The Performance Virtual Group's mission is to empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

Sign in to Subscribe

Meeting Details

Things You Can Find in the Plan Cache

Thu, Apr 24 2014 18:00 UTC

Things You Can Find in the Plan Cache

The Plan Cache is one of SQL Server's fundamental components, and getting to know it will take your troubleshooting and performance tuning skills to the next level. In this session we will demonstrate a few basic and advanced ways we can use the Plan Cache in order to identify and solve query performance problems. Among other topics, we will talk about: * How an Execution Plan is generated * The right ways to use parameters * How to overcome Parameter Sniffing problems * Common performance problems and solutions * What insanely valuable data we can pull out of the Plan Cache And much more..


Matan Yungman

Matan Yungman is a Data Platform MVP, a senior consultant and the professional manager at Madeira Data Solutions. He has been working with SQL Server since 2002, and today he spends his time consulting, mentoring, teaching and speaking about SQL Server. Matan also co-hosts SQL Server Radio, a podcast for SQL Server professionals. He is passionate about SQL Server, technology and the SQL Server community.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids