SQL SERVER – Reduce the Virtual Log Files (VLFs) from LDF file

Earlier, I wrote a quite note on SQL SERVER – Detect Virtual Log Files (VLF) in LDF. Because of this I got responses suggesting too many VLFs are bad for log file. This prompts to a simple question: “How many is ‘too many’ VLFs?” I suggest that you go and read an article written by Kimberly … Continue reading SQL SERVER – Reduce the Virtual Log Files (VLFs) from LDF file