SQL SERVER – Query to List Active and Inactive VLF

(Pinal Dave) Recently, I had a very interesting experience with one of my clients where we observed a large number of VLF files impacting negatively to their performance. We used the in-famous DBCC SHRINKFILE to reduce the VLFs.

Register to Read