Webinar: Query Progress Tracking in SQL Server

0 0 1 minute read

Today, October 13th, at 2:00 PM EDT, SQL Sentry is sponsoring a webinar hosted by Matan Yungman, entitled “Query Progress Tracking in SQL Server.” Here is the abstract:

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 for 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. Last but not least, we will also talk about the new shiny SQL Server 2016 Live Query Statistics tool.

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.

SQLPerformance.com

SQLPerformance.com is about providing innovative and practical solutions for improving SQL Server performance. Whether you are running a 3rd party application database where very little can be changed, or you are a DBA at a site where getting the application developers to change anything is next to impossible, industry experts including Paul Randal, Jonathan Kehayias, Erin Stellato and Paul White will cover both the “how” and the “why.”