First of all – if you are going to say this is very old subject, I agree this is very (very) old subject. I believe in earlier time we used to have this only option to monitor Log Space. As new version of SQL Server released we all equipped with DMV, Performance Counters, Extended Events and much more new enhancements. However, during all this year, I have always used DBCC SQLPERF(logspace) to get the details of the logs. It may be because when I started my career I remember this command and it did what I wanted all the time.
I have decided to do some interesting experiments every weekend and share it next week as a weekend project on the blog. Many times in our business lives and personal lives are very separate, however, this post will talk about one instance where my two lives connect.
