Let us take a close look at the active VLF in an SQL server. At Bobcares our MSSQL support services can give you a detailed note on the whole process.
Role of Active VLF in SQL server
It is crucial to remember that the VLF, rather than a single log record or log block, is the smallest unit of truncation in the log file. The whole VLF is regarded as active and cannot be shortened if there is just one log entry in a VLF that is still a part of the active log.
A VLF can, in general, be in either an active or an inactive physical state. However, based on the many ‘behaviors’ that a VLF could exhibit, we can distinguish four logical states:
- Active: The VLF in this state is active because at least one of its log records is a component of the active log. This makes it necessary for rollback or other operations.
- Recoverable: A VLF is recoverable when it is dormant but not