Query Progress

Question

Query Progress

muhammad.farhan 29574

SSC Enthusiast

Points: 121
More actions
January 26, 2016 at 9:53 pm

#323883

Comments posted to this topic are about the item Query Progress
January 26, 2016 at 11:57 pm

This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 1

Based on the title of the question, the answer is good. However, specifically for the text in the question (which explicitly limits the query type to backup and restore), I would prefer the answer "by adding WITH STATS to the backup or restore statement before you submit it"

For the progress indication in dm_exec_requests, beware that there are can be some caveats . I recently used it on a DBCC CHECKDB and found that this apparently has multiple phases and the percentage indicated appears to be for the current phase, not for the statement as a whole.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 2

For the progress indication in dm_exec_requests, beware that there are can be some caveats . I recently used it on a DBCC CHECKDB and found that this apparently has multiple phases and the percentage indicated appears to be for the current phase, not for the statement as a whole.

Good notice.

I'm noticing it for DBCC SHRINKDATABASE as well.

Igor Micev,My blog: www.igormicev.com