Find Percent Completion of Process

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.status,
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 : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts
Instagram : https://www.instagram.com/knowledgesharingplatform