Find Percent Completion of Process

Share via:

Find Percent Completion of Process

This script is to find the percent of completion of backup, restore, DBCC commands etc.

SELECT req.session_id, sqltext.TEXT,
req.command, req.wait_type, req.wait_time,
(req.estimated_completion_time/1000/60) as est_min, req.percent_complete
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
join sys.dm_exec_sessions ses on ses.session_id = req.session_id
where req.session_id > 50


Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook :
LinkedIn :
Twitter :
YouTube :
Instagram :

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (9 votes, average: 5.00 out of 5)

One thought on “Find Percent Completion of Process

Add Comment