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.

Login to Subscribe

Welcome to the Performance Virtual Group

Next Meeting

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.

Contact the Performance Virtual Group

Are you interested in being a Presenter, getting involved with the Group or simply provide us with some feedback? Please fill in the form below

Your Contact Information

Your Feedback

Thank you for contacting us, we will get back to you as soon as possible!
Back to Top