Tuesday 13 November 2012

SQL Server: Use DBCC SQLPERF statement to see LOG space usage


You can use DBCC SQLPERF statement to observe log space usage.
For example;
1DBCC SQLPERF(LOGSPACE);
2GO
Output:
Database Name 
Log Size (MB)   Log Space Used (%) Status
-----------------------------------------------------
master
0.9921875      52.75591             0
tempdb
0.4921875      85.71429             0
model
0.4921875       80.95238            0
msdb
5.054688       15.37867             0
ReportServer$SQL2K8R2
6.742188       16.74392              0
ReportServer$SQL2K8R2TempDB
0.7421875      44.21053             0
AdventureWorks2008R2
1.992188       18.43137              0
AdventureWorksDW2008R2
1.992188       31.76471              0
AdventureWorks
1.992188       21.37255              0
AdventureWorksDW
1.992188       27.64706              0
(10 row(s) affected)

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

No comments:

Post a Comment