[Script Of Auguest 1] How to check VLF information in SQL Server

imageimage
Aug.
1
imagehttps://gallery.technet.microsoft.com/How-to-check-VLF-5bf8597f.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.

This script will list the actual log size, used log space, number of actual VLFs, number of used VLFs and other related information of all databases in an instance. Besides, the script will proactively list potential log size and the number of potential VLFs.

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