14,494 questions
You mean that you want to have IFI on some drives and not on others? I have never heard of such an option, and given that it is controlled by a Windows permission, I can't see how there could be.
disable zero file initialization on fsx drives.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 54%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Heisenberg
261
Reputation points
we have non production database server on AWS and our AWS admin has created an FSX drive for hosting the database files. is there any way to disable zero file initialization on these drives or is it same as mentioned in the below article.
SQL Server Other
{count} votes
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff2021-08-09T01:33:18.41+00:00 Hi @SQLServerBro,
Just checking in to see if the answer(s) helped.
If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.
And If you have further questions or issues please let us know.
Sign in to comment
4 answers
Sort by: Most helpful
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2021-08-04T17:01:35.813+00:00 -
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
2021-08-05T06:33:18.993+00:00 Hi @SQLServerBro,
>is there any way to disable zero file initialization on these drives or is it same as mentioned in the below article.
IFI is applied to data files,
In SQL Server, for data files only, instant file initialization (IFI) allows for faster execution of the previously mentioned file operations, since it reclaims used disk space without filling that space with zeros.
And instant file initialization is only available if the SQL Server service startup account has been granted SE_MANAGE_VOLUME_NAME. Members of the Windows Administrator group have this right and can grant it to other users by adding them to the Perform Volume Maintenance Tasks security policy.
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.
-
Heisenberg 261 Reputation points
2021-08-05T17:55:16.337+00:00 I think i didn't phrase my question correctly. I mean to say i want to enable IFI for fsx drives. The configuration as mentioned in the below article applies to FSX drives too?
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
2021-08-06T07:30:39.273+00:00 Hi @SQLServerBro,
> I mean to say i want to enable IFI for fsx drives. The configuration as mentioned in the below article applies to FSX drives too?
No, IFI is only applied to data files.
But if you mean enable IFI on data files that storage on Amazon FSx, the answer is yes.
Refer to the blog Enable instant file initialization for SQL server on Amazon EC2.
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.