SQL Server Performance

What will be the write sequence of VLF?

Discussion in 'SQL Server 2008 General DBA Questions' started by mishrsk, Jul 13, 2010.

  1. mishrsk New Member

    Hello,
    Suppose I have 4 VLFs sequentially numbered VLF1, VLF2, VLF3 and VLF4 for one of my databases. Say VLF2 and VLF4 are active and VLF1 and VLF3 are unused/inactive.
    Q1. Is this scenario possible that VLF2 and VLF4 remain active and VLF3 in between will be free/inactive?
    Q2. If above is possible, then when VLF2 becomes full which VLF will be used next?
    Many Thanks in advance.
    mishrsk, Jul 13, 2010
    #2

  2. satya Moderator

    satya, Jul 13, 2010
    #3

  3. mishrsk New Member

    Thanks Satya, got the answer.
    mishrsk, Jul 13, 2010
    #4

Share This Page