SQL Server: Use DBCC SQLPERF statement to see LOG space usage
You can use DBCC SQLPERF statement to observe log space usage.
For example;
1 | DBCC SQLPERF(LOGSPACE); |
2 | GO |
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