VLFs the Forgotten Foe
How many of you check the amount of Virtual Log Files (VLFs) your transaction logs have? Working as a consultant now, I see this as something that is often ignored by DBAs. This is an easy thing maintain and yet so many don’t know how to. Keeping these in check can give you a performance boost not only on startup but with your insert/update/delete as well as backup/restore operations. SQL Server performs better with a smaller number of right sized virtual log files. I highly recommend you add this to your server reviews. What is a VLF? Every transaction log… Continue Reading
