DBAgent Issue handling pages
Issue 24: Database Virtual Log Files: Sized suboptimal
A transaction log is devided into chunks, called Virtual Log Files or VLFs. These chunks are created when the log grows. In general, the smaller the growth factor of the transaction log, the more VLFs are created. Over time that can result in many thousands of VLFs.
A large number of VLFs can slow down the recovery process that a database goes through on startup or after restoring a backup.
DBCC LOGINFO gives you information about the VLFs in the current database.
Links that could be useful:
> Home >< Back <