[Script of Oct. 4] Check VLF information (T-SQL)

  • Article

Script Download: VLFinfo.zip
https://gallery.technet.microsoft.com/scriptcenter/Check-VLF-information-T-SQL-f7e2bd94

This script will list the actual log size, used log space, actual VLFs and used VLFs etc. information of all databases in an instance. Besides, the script will proactively list potential log size, potential VLFs of based on the current size of the transaction log.

The script will list information about VLFs about all the databases in an instance.

image image
image

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery