Database Administration img_5512d3113768b

Published on March 25th, 2015 | by Warner Chaves

3

Presentation: Profiling a problem query with XEvents and SQL DMVs

I’m honored to be presenting a webcast tomorrow with the SQL PASS Performance Virtual Chapter on using XEvents and DMVs to profile a query’s behavior:

“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!”

Register here: https://attendee.gotowebinar.com/register/118799297508520705

See you there!

UPDATE:

Thanks for attending today everybody! Great questions at the end as well.

Here’s the download package: https://www.dropbox.com/s/384qu4koc4wilfr/ProfilingQueries.zip?dl=0

Tags: , , , , , , ,


About the Author

SQL Server Certified Master and MVP. DBA for MS technologies for over 10 years.



3 Responses to Presentation: Profiling a problem query with XEvents and SQL DMVs

  1. sarah.falkavage@sentry.com' Sarah Falkavage says:

    Great session today Warner!
    Thanks for the great info!

  2. jonesboy21@gmail.com' Dustin Jones says:

    Nice presentation today

  3. Warner Chaves says:

    Thanks guys!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Back to Top ↑
  • Sign Up For Our Newsletter

    Stay up to date on the latest from SQL Server products and Features.

    Sign Up Now

    Sign up for mailing list and receive new posts directly to your inbox.

    We promise never to share or sell any of your personal information.

  • Recent Posts

  • Categories

  • Archives

  • Tags

  • Topics

  • Subscribe to our RSS Feed


    sqlturbo.com A SQL Server Web Blog
    Canada, Ontario, Ottawa.
    http://sqlturbo.com

    The Authors