Check SQL Server Database restore progress and time used.

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.