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 a part of SolarWinds.  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...Longky Chandra!

 

GoToWebinar requires registration through the RSVP link below.
Next Meeting

Thu, Mar 26 2015 14:00 Eastern Daylight Time


Profiling a problem query with XEvents and SQL DMVs

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

Recording: None

Profiling a problem query with XEvents and SQL DMVs

As DBAs we are responsible for our databases performance. When things go slow, users will look over to us and expect our tuning to be efficient, effective and timely. For those times when a simple look over the execution plan is not enough, Extended Events and the engine DMVs can provide the level of detail needed to analyze the most granular details about an execution. In this demo heavy session we will look at example XEvents session to use for troubleshooting slow queries and quickly manipulate them to get results. We will also take a look at the main DMVS that can help with query troubleshooting including the new dm_exec_query_profiles view in SQL Server 2014. Come see why no bad query can hide under the lens of XEvents and DMVs!


Warner Chaves is a SQL Server MCM and SQL Server Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, managing multiple customers and instances in many versions and industries while leading a highly talented team of SQL Server DBAs.