Pedro Lopes
Pedro Lopes Minor update
Latest commit a140106 Nov 4, 2016
Failed to load latest commit information.
Fix_VLFs.sql Minor update Nov 4, 2016 Added more solutions Nov 3, 2016

Change log and other information available at - SQL Swiss Army Knife Series

Purpose: Gets an overview of the current VLF status in all databases of a given instance, and if the number of VLFs are above a pre-determined threshold, also makes a suggestion of how many and how large the VLFs should be for that particular database.

In the output, you will find the following information:

  • The database name;
  • The transaction log current size and the size it will be after applying suggested changes. Both in MB;
  • The current number of VLFs and the number of VLFs that will remain after applying suggested changes;
  • The amount of growth iterations necessary to get to the suggested size;
  • The transaction log initial size and the autogrow size that should be set;

In addition, a script is generated with the typical example steps needed to deal with the issue, depending on whether the database is in Simple recovery model or not.