Using sys.dm_exec_requests to estimate completion time for a process

Question

Viewing 4 posts - 1 through 3 (of 3 total)

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

chvreddy78 SSC Enthusiast Points: 122 More actions · Answer 1

SSC Enthusiast

Points: 122

October 5, 2011 at 1:57 am

very good article

Mehernosh SSC Eights! Points: 826 More actions · Answer 2

Nice script Smitha.

Just a quick addition to your script , in regrads to backups and restores we could use the STATS option which will show the percentage as required.

But I normally use this script to check and find out the remaining time duration.Similar to your post,

http://www.sqlservercentral.com/Forums/Topic1146594-338-1.aspx

😀

Regards,

Mehernosh.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

SSC Guru

Points: 76202

May 12, 2016 at 6:51 am

Thanks for the script.