  
Aug.
1
|
 https://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
|