Informations sur opérations en cours

Lorsque vous lancez un backup, un restore ou un dbcc shrinkfile, cette requête vous permet d’avoir une estimation du temps restant pour l’opération en cours.

/*-------------------------------------------------------------------
[SCRIPT] Informations sur opérations en cours : backup, restore ou shrinkfile
[DESCRIPTION] Fournit la durée estimée pour terminer l'opération
[MAJ PAR] DATAFLY - Arian Papillon
[DATEMAJ] 20200120 
-------------------------------------------------------------------*/
SELECT session_id,
       status,
       command,
       DB_NAME(database_id) AS DBName,
       start_time AS [Start Time],
       estimated_completion_time / 3600000 AS [Estimated Completion Time (Hours)],
       total_elapsed_time / 60000 AS [Elapsed Time (Minutes)],
       CAST(percent_complete AS DECIMAL(5, 2)) AS [Percent Complete]
FROM sys.dm_exec_requests
WHERE command = 'DbccFilesCompact'
      OR command = 'BACKUP DATABASE'
      OR command = 'RESTORE DATABASE'
      OR command = 'DbccSpaceReclaim'
      OR percent_complete > 0;

/*-------------------------------------------------------------------

[SCRIPT] Informations sur opérations en cours : backup, restore ou shrinkfile

[DESCRIPTION] Fournit la durée estimée pour terminer l'opération

[MAJ PAR] DATAFLY - Arian Papillon

[DATEMAJ] 20200120

-------------------------------------------------------------------*/

SELECT session_id,

status,

command,

DB_NAME(database_id) AS DBName,

start_time AS [Start Time],

estimated_completion_time / 3600000 AS [Estimated Completion Time (Hours)],

total_elapsed_time / 60000 AS [Elapsed Time (Minutes)],

CAST(percent_complete AS DECIMAL(5, 2)) AS [Percent Complete]

FROM sys.dm_exec_requests

WHERE command = 'DbccFilesCompact'

OR command = 'BACKUP DATABASE'

OR command = 'RESTORE DATABASE'

OR command = 'DbccSpaceReclaim'

OR percent_complete > 0;