Log File VLFs

Question

Log File VLFs

Viewing 6 posts - 16 through 20 (of 20 total)

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

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 1

george sibbald (1/12/2011)
from QOTD of 7th JAn
log created at:
less than 64MB - 4 VLFs
64MB and less than 1GB - 8 VLFs
1GB or greater - 16VLFs

Nice memory

george sibbald SSC Guru Points: 104210 More actions · Answer 2

Steve Jones - SSC Editor (1/12/2011)
george sibbald (1/12/2011)
from QOTD of 7th JAn
log created at:
less than 64MB - 4 VLFs
64MB and less than 1GB - 8 VLFs
1GB or greater - 16VLFs
Nice memory

thanks!. shows I was paying attention. 🙂

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

Cliff Jones SSChampion Points: 10547 More actions · Answer 3

Another good question. I thought that the correct answer was one but had to create a database and verify with DBCC Loginfo.

lukus_g SSC Eights! Points: 958 More actions · Answer 4

great question today 🙂

i went right ahead and clicked 4... then read the question again... "active"... d'oh.

UMG Developer SSChampion Points: 13482 More actions · Answer 5

UMG Developer

SSChampion

Points: 13482

January 21, 2011 at 3:20 pm

#1276833

Thanks for the question!

Paul White SSC Guru Points: 150467 More actions · Answer 6

When I create a database, I get two active VLFs according to DBCC LOGINFO.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi