Using sys.dm_exec_requests to estimate completion time for a process

• Smitha Reddy

  SSC Enthusiast

  Points: 109

  More actions

  October 5, 2011 at 1:51 am

  #248890

  Comments posted to this topic are about the item Using sys.dm_exec_requests to estimate completion time for a process

• chvreddy78

  SSC Enthusiast

  Points: 122

  More actions

  October 5, 2011 at 1:57 am

  #1390527

  very good article

• Mehernosh

  SSC Eights!

  Points: 826

  More actions

  October 17, 2011 at 12:44 am

  #1395146

  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

  May 12, 2016 at 6:51 am

  #1878530

  Thanks for the script.