Guest Posts

Webinar : Query Progress Tracking in SQL Server

October 12, 2015 by in SQL Plan | No Comments
SentryOne eBooks

In these books, you will find useful, hand-picked articles that will help give insight into some of your most vexing performance problems. These articles were written by several of the SQL Server industry’s leading experts, including Paul White, Paul Randal, Jonathan Kehayias, Erin Stellato, Glenn Berry, Aaron Bertrand, and Joe Sack.

Free Download

Featured Author

Itzik is a T-SQL trainer, a co-founder of SolidQ, and blogs about T-SQL fundamentals and query tuning.

Itzik’s Posts

On October 13th, at 2:00 PM EDT, SQL Sentry sponsored 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.