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

  • 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))

INSERT INTO #Resultat(DatabaseName, LOGSIZE_MB, LOGSPACE_USED_PERCENT, LOGSTATUS)
EXEC ('DBCC sqlperf(logspace)')

SELECT * FROM #Resultat ORDER BY LOGSIZE_MB desc