Author Topic: How to know the number of VLF created on a given database log file?  (Read 398 times)

Offline Woody

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
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.
« Last Edit: December 09, 2017, 05:59:56 PM by Sofyene »



Offline Haydn

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
Re: Number of VLF
« Reply #1 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


 

Sitemap 1 2 3 4 5 6 7 8 9