Enabling Instant File Initialization can potentially improve over performance. It works a similar manner as thick eager provisioning in vCenter than letting it grows as it needs by zeroing the disk.
How To Enable Instant File Initialization
1. Open Local Security Policy and go to Local Policies –> User Rights Assignment.
How To Enable Instant File Initialization
1. Open Local Security Policy and go to Local Policies –> User Rights Assignment.
2. Double click Perform Volume Maintenance Tasks and add your SQL Server database engine service account.
3. Restart the SQL Server service using SQL Server Configuration Manager and this setting should now be enabled.
No comments:
Post a Comment