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.
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);
Posted on June 19, 2013, in Maintenance and tagged DBCC, Maintenance. Bookmark the permalink. Leave a comment.
Leave a comment
Comments 0