You can use DBCC SQLPERF statement to observe log space usage. For example; DBCC SQLPERF(LOGSPACE); GO 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 ...
Read More
You can use DBCC SQLPERF statement to clear wait & latch stats. For example; -- clear the wait stats DBCC SQLPERF('sys.dm_os_wait_stats',CLEAR); You can use this statement to also clear latch stats. For example; -- clear the latch stats DBCC SQLPERF('sys.dm_os_latch_stats',CLEAR); If you like the tip, do like us on FaceBook at http://www.FaceBook.com/SQLServerGeeks @SQLServerGeeks