SQL Instant File initialization

  • What I am seeing. If I use the Instant File Initialization, then you will be able to grow the files easily, however when SQL Server Storage engine gets to write the data to the pages, as the pages are accessed, they need to be zeroed before the data can be written. The latter means a write delay, of course. Either use the Instant file initialization or don’t use it for significant size?

  • Always use IFI unless you have disk data that you really can't have anyone else see via some type of hack.

    Data pages do not need to be zeroed out before being written to, only log pages.

     

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

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

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