Use the below statement to monitor SQL Server Database restring progress and time used.
SELECT
session_id,
command,
start_time,
status,
percent_complete,
estimated_completion_time,
total_elapsed_time
FROM
sys.dm_exec_requests
WHERE
command = 'RESTORE DATABASE';
Note: Use this statement while restoring in progress only.
