THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Michael Zilberstein

New DMV… not yet

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.

Published Monday, July 1, 2013 5:31 PM by Michael Zilberstein



Michael Zilberstein said:

Remember the excitement about new sys.dm_exec_query_profiles DMV? It promised to be a gamechanger, providing

October 16, 2013 8:34 PM
New Comments to this post are disabled
Privacy Statement