DBCC Loginfo

  • Hello,

    I have started looking in to the amount of VLF's I have in my DB's logs, but I am not sure what the results are telling me.

    As I am sure you will know, I get the following headings...

    FileID, Filesize, StartOffset, FSeqNo, Status, Parity, CreateLSN

    I have had a good look on the web for a resource that might actually explain what ALL the columns results mean, but I have not found anything as yet. Does anyone know of a site or blog that can explain them? I understand that the number of rows that come back in the results are number of VLFs I have, but that's about it.

    Any advice or pointers would be fantastic.

    Thank you,

    D.

  • In my experience only the status column is of interest. If the value = 2 the vlf contains active transactions, if it = 0, it does not.

    If status = 2 in the last row that explains why the log will not shrink any further.

    ---------------------------------------------------------------------

  • ah, that makes sense, out of 160 rows one of them =2 about half way down.

    Thanks for taking the time.

    D.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply