Query Progress Tracking in SQL Server

It's 18:00 o'clock on Friday. You execute a process that usually takes a few minutes and start packing in order to start the weekend. You are already with your bag on your back, but the process doesn't finish. You start cursing yourself for not waiting to Monday, take off your bag and start searching for the problem. What should you do now?
In this hands-on session, we will go over the ways SQL Server gives us for tracking progress of processes and queries, and identifying bottlenecks in real-time. Among other topics, we will talk about the percent_complete column, how the CXPacket wait type can help us, to Rollback or not to Rollback, and how the new sys.dm_exec_query_profiles DMV can help us.
Presented by Matan Yungman at SQLBits XII
Tags (no tags)
  • Downloads
    Slide deck available Slide Deck 1.7 MB
    Samples available Demo Code 3 KB
    Video available MP4 Video HD 378 MB
  • SpeakerBIO

    Matan Yungman is a SQL Server 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.

    http://www.madeiradata.com/blog/ http://www.madeiradata.com/blog/feed
  • Video