Webastor - Programming Tips and Tricks

Programming language => Sql => Topic started by: Woody on October 31, 2014, 12:09:08 AM

Title: How to know the number of VLF created on a given database log file?
Post by: Woody on October 31, 2014, 12:09:08 AM
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.
Title: Re: Number of VLF
Post by: Haydn on December 09, 2017, 06:03:26 PM
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