THE SQL Server Blog Spot on the Web

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

Kevin Kline

Checking for operation completion


Here's a tip that comes by way of MVPs Dr. Tom Moreau (no, not that Dr. Moreau) and Tibor Karaszi (

You probably know that you can backup a database and add WITH STATS = ... to get the running percentage progress of the backup. Have you ever wondered if there's a DMV that captures this information?

You might try checking out sys.dm_exec_requests and it's columns, percent_complete and estimated_completion_time columns. Tibor mentions that according to his notes, those columns should be populated for operations including:


Of course, it would be really interesting to see a full list of the commands that populates the DMV with this information.  Let me and other readers know by posting a note here if you try another command and find that it's also tracked by sys.dm_exec_requests.

Best regards,


Published Monday, March 26, 2007 1:40 PM by KKline
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS,

This Blog


Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement