September 2, 2010 at 5:08 am
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.
September 2, 2010 at 6:46 am
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.
---------------------------------------------------------------------
September 2, 2010 at 8:15 am
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