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.