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

Welcome to the Performance Virtual Chapter

The Performance Virtual Chapter events are held on the 4th Thursday of each month at 2PM ET.  Every month there is a drawing for a $100 Amazon gift card sponsored by Confio.  To be eligible, you just need to attend our monthly webcast.  A winner will be randomly chosen from all those in attendance for the whole webcast who provide their email address. 



You can follow us on Twitter @SQLPASS_PVC

Join our Google Group Distribution List for the latest updates and meeting announcements.

Congratulations to the February Gift Card Winner...Don Tuxworth!

 

GoToWebinar requires registration through the RSVP link below.
Next Meeting

Thu, Apr 24 2014 14:00 (GMT-05:00) Eastern Time (US & Canada)


Things You Can Find in the Plan Cache

RSVP: https://attendee.gotowebinar.com/register/1957378445191336449

Recording: None

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 is a Technology Evangelist for Madeira SQL Server Services. He has over 10 years of experience working with SQL Server, focusing mainly on performance tuning, high availability, database development and database design. Matan also co-hosts the Israeli SQL Server Radio show. He is passionate about SQL Server, technology and the SQL Server community.