Downloaded and installed new toy:
And while reading BOL, stumbled upon new extremely useful DMV: sys.dm_exec_query_profiles. This DMV enables DBA to monitor query progress while it is being executed. Counters in the DMV are per operation per thread. So we’ll be able to monitor in real time which thread (even for parallel processing) processes which node in the plan. Or find heavy operations “post mortem”. We all know the uncomfortable feeling when some heavy query runs and the boss starts asking “stupid” questions like “when would it finish” or “what percent of execution is already beyond us”. We don’t have answer for that. New DMV provides at least partial answer as first time it enables to drill down into query execution progress. That’s not the “percent_completed” column that we monitor on DBCC CHECKDB or BACKUP operations. But as close as it can be.
See you next CTP, I guess.