[SQL Server] Afficher le pourcentage d'utilisation des logs (journaux, journal) Méthode 2

  • Imprimer

IF EXISTS(SELECT * FROM tempdb..sysobjects WHERE id = object_id(N'[tempdb]..[#Resultat]'))
BEGIN
DROP TABLE #Resultat
END

CREATE TABLE #Resultat
(
DatabaseName varchar(100)
, LOGSIZE_MB decimal(18, 9)
, LOGSPACE_USED_PERCENT decimal(18, 9)
, LOGSTATUS decimal(18, 9))

EXEC sp_msforeachdb 'USE [?];
INSERT INTO #Resultat(DatabaseName, LOGSIZE_MB, LOGSPACE_USED_PERCENT, LOGSTATUS)
SELECT DB_NAME(database_id) AS [Database Name]
,(total_log_size_in_bytes*1.0/1024)/1024 [Log Size (MB)]
,(used_log_space_in_bytes*1.0/1024)/1024 [Log Space Used (MB)]
,used_log_space_in_percent [Log Space Used (%)]
FROM sys.dm_db_log_space_usage'

SELECT * FROM #Resultat ORDER BY LOGSIZE_MB desc