How to find SQL Server database Restore and Recovery time ?

Easy to way to determine Restore and Recovery time.

Simple query to find out SQL Server Database restore time and percentage of completion.

SELECT 
 percent_complete as percentageComplete
 ,estimated_completion_time/60000 as timeToComplete
 ,status 
FROM
 sys.dm_exec_requests 
WHERE
 command like '%restore%'

Simple query to find out SQL Server Database recovery time and percentage of completion.

SELECT
 percent_complete as percentageComplete
 ,estimated_completion_time/60000 as timeToComplete
 ,status
FROM
 sys.dm_exec_requests 
WHERE
 command like '%recovery%'

Source :

How to find SQL Server database Restore and Recovery time ? | by Ganesh Chandrasekaran | Medium

Ganesh Chandrasekaran ・ Sep 8, 2020 ・

Medium