Jeff Moden (8/16/2016)

---

BLOB_EATER (8/16/2016)

---

Jeff Moden (8/16/2016)

---

BLOB_EATER (8/16/2016)

---

Where can I find info on Log files can use instant file initialization? I thought differently so I am very curious now (unless I read Jeff's post wrong)

Yes... kind of reading that wrong. Using instant file initialization does virtually nothing for log files because they have to be "formatted" with VLFs.

Oh I get it now - the parity bits within log sectors.

I've not actually studied the structure of a VLF so I can't say whether it's parity bits within log sectors or what. I only know that the VLFs have to be "laid out" in the file (essentially, custom formatting within the file) before the new areas of the file can be used. Someone like Gail Shaw would probably be able to get much more detailed about what goes on during that evolution. I only know that it happens and it takes a comparatively long time and is one of the reasons why I do pay good attention to the size of my production log files... I get that log files are necessary and that they sometimes necessarily get a bit large but the bigger they are, the longer it takes to do a restore, especially in a panic. Because of the improvements we've made to the code in our shop over time, most of our half tera-byte databases require 20GB or less.