TSQL to identify databases with high number of VLFs

If you aren’t aware there can be significant impact to performance when a database has a high number of VLFs within it’s Transaction Log. SQL Server divides each physical transaction log file internally into a number of virtual log files (VLFs) and it is these that contain the log records.  There is no fixed size for a…

1