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

Profiling a problem query with XEvents and SQL DMVs

Thu, Mar 26 2015 18:00 UTC

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! Link to Warren’s blog with info about the session and downloads: http://sqlturbo.com/presentation-profiling-a-problem-query-with-xevents-and-sql-dmvs/


Warner Chaves

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.

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
cage-aids
cage-aids
cage-aids
cage-aids