Instant File Initialization with TDE

If you are using Transparent Data Encryption TDE and have Instant File Initialization turned on, you are not getting the benefits of Instant File Initialization.

Microsoft does not provide many details around the reasoning why but I would have to assume that since data is encrypted at the page level, that TDE has to still zero out the file. You can read what Microsoft has to say on TDE here

This entry was posted in SQLServerPedia Syndication. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *