Tag Archives: VLF

Want to Make Your SQL Server Run Faster for Free?

Want to Make Your SQL Server Run Faster for Free? The trick is to properly manage your VLFs. What are VLFs? The short anser is that VLF stands for virtual log file. SQL Server database log files are made up of many smaller virtual log files that make it easier for SQL Server to manage the log files. Continue reading

Posted in File Management | Tagged , , | 4 Comments

A Busy/Accidental DBA’s Guide to Managing VLFs

Introduction Properly managing VLFs can make or break the performance of your databases. There is a ton of information out there on the proper management of VLFs, but nothing I have found that tries to boil it down to the … Continue reading

Posted in File Management | Tagged , , | 14 Comments