VSUS (VLF Segments of Unusual Size)

Enjoying another little train trip around an airport. and while waiting around for my flight I thought I would try and tackle fixing that 16 VLF segments of 16 GB each situation I described in my previous blog post. You might just think “well that should be just like fixing the too many VLFs issue, just shrink it down…

0

If > 50 VLFs are bad, then 16 is good, right?

Exhibit A:  256 GB transaction log file with 16 VLFs.  Doing the quick math that would make each VLF 16GB.  16 x 16GB VLFs = 256GB transaction log. (yes, that is a large transaction log) All this guidance I see says 50 VLFs would be too many. Okay, not too many VLFs, so we should be fine……

0