Enable instant file initialization - AWS Prescriptive Guidance

Enable instant file initialization

When a database files grows, it fills the new disk space with zeros (0x0) by default. This creates significant system I/O and can degrade system performance. Instant file initialization prevents zeroing operations on the allocated disk space. To enable instant file initialization, follow the steps in the Best practices for deploying SQL Server on Amazon EC2 guide.