transaction log

Check transaction log space used for SQL Database

Posted on

DBCC SQLPERF (LOGSPACE) WITH NO_INFOMSGS

http://msdn.microsoft.com/en-us/library/ms189768.aspx

Database Name Log Size (MB) Log Space Used (%) Status
------------- ------------- ------------------ -----------
master         3.99219      14.3469            0
tempdb         1.99219      1.64216            0
model          1.0          12.7953            0
msdb           3.99219      17.0132            0
AdventureWorks 19.554688    17.748701          0