Blog Archives

Are Those Transaction Logs Empty?

Ever wonder what your usage statistics are for your transaction log files without opening each individual one in the SQL Server Management Studio shrink file dialog.  DBCC SQLPERF is a neat little utility that can tell you the size of the log file and the amount of the space occupied by transactions inside the file.

DBCC SQLPERF

DBCC SQLPERF

You can also use this utility to clear the sys.dm_os_wait_stats and sys.dm_os_latch_stats statistics, in such a manner:

DBCC SQLPERF(“sys.dm_os_wait_stats”,CLEAR);

%d bloggers like this: