February 5, 2021 at 7:43 pm
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?
February 5, 2021 at 9:04 pm
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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply