THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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 (http://www.karaszi.com/sqlserver/default.asp).

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:

DBCC CHECKDB
DBCC SHRINKDATABASE
DBCC SHRINKFILE
BACKUP DATABASE
ROLLBACK

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,

-Kevin

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

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

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, www.sqlpass.org.

This Blog

Syndication

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