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 Technical 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 SQL Server Radio podcast on SQLServerRadio.com. He is passionate about SQL Server, technology and the SQL Server community.
    http://www.madeirasql.com/blog/ http://www.madeirasql.com/blog/feed
  • Video