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: 33110 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

Hany Helmy SSChampion Points: 13921 More actions · Answer 3

Using this 1 a lot, thanx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

andrew_dale Ten Centuries Points: 1326 More actions · Answer 4

nice question I had no idea so googled it and came up with this article

https://www.mssqltips.com/sqlservertip/2343/how-to-monitor-backup-and-restore-progress-in-sql-server-2005-and-2008/

Ed Wagner SSC Guru Points: 287026 More actions · Answer 5

One of my favorites. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 6

Thanks for the question.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 7

akljfhnlaflkj

SSC Guru

Points: 76202

February 25, 2016 at 4:51 pm

#1861296

Thanks for the question.

Query Progress

Cookies on SQLServerCentral