Dear All,

You can use DBCC SQLPERF(‘logspace’) command to observe the Log File size:

The output is as follows:


But its hard to filter the data here. So we can use the DMV sys.dm_os_performance_counters as follows:

Here is the output:


And you can filter the way you want. More techniques welcomed.



Rahul Sharma

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook