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
Leave a Reply