Sql Server : How to check transactional log file usage
- Posted by Sqltimes
- On July 11, 2015
- 0 Comments
Quick one today:
Sometimes there is a need to track the usage patterns of transactional log file usage. There is a quick and efficient way to gather this data on regular basis.
|
1
2
3
4
5
|
---- Check the log file space usage--DBCC SQLPERF(LOGSPACE)GO |
It gives, Database Name, Log Size (MB), Log Space Used (%) and status. See the sample image below:
Log Space Usage
Previously, we saw a different usage of DBCC SQLPERF to reset DMV counters.
Hope this helps,
_Sqltimes
0 Comments