How to know the number of VLF created on a given database log file?

Started by Marlon, October 31, 2014, 12:09:08 AM

Previous topic - Next topic

Woody

Hello, I would like to submit a question concerning the field of health, how to know the number of vlf created on a given database log file? It is urgent, thank you please give me your opinion quickly.

Haydn

SQL script that iterates over all online databases for an instance and produces a list of databases and the count of Virtual Log Files (VLFs). The SQL Server Database Engine divides each physical log file internally into a number of virtual log files.  having too many or too fe