fetching/tracking currently running Backup database details

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 279
Sometimes, the server can be very slow or the long running queries cause the server slowness..

At that time we suppose to analyse that whether there are any long running queries or backup database query in instance/server.

To know the Backup database details at run time i.e. how much percentage the backup process completed, on which database the backup database command is running, how long it is executing...


SELECT session_id as SPID, command, a.text AS Query, start_time, percent_complete, dateadd(second,estimated_completion_time/1000, getdate()) as estimated_completion_time
FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a
WHERE r.command in ('BACKUP DATABASE','RESTORE DATABASE')

Comments or Responses

Login to post response