Copy the script to SSMS
Run it
Ensure that you have viewserverstate permission assigned.
----------------------------------------------------------------------------------------
declare @SQLPerfLogSpace table
(
DBNAME sysname,
LogSizeMB decimal(10,4),
LogSpaceUsed decimal(10,4),
Status Bit --Status of the log file. Always 0.
)
insert into @SQLPerfLogSpace exec('DBCC SQLPERF(logspace)')
select * from @SQLPerfLogSpace
Order by LogSizeMB desc
select * from @SQLPerfLogSpace
Order by LogSpaceUSed desc
