topic SQL Server Instant File Initialization in Data Protection https://community.netapp.com/t5/Data-Protection/SQL-Server-Instant-File-Initialization/m-p/49224#M9449 <HTML><HEAD></HEAD><BODY><P>I'm trying to get a definitive answer as to whether this feature has any value when sql server data is stored on a Netapp device.&nbsp; If you turn this feature on in Windows Server, when SQL Server needs new disk space for a growing data file, it does not have to "zero out" the new space but puts the new space into use immediately.&nbsp;&nbsp; I'm getting different answers as to whether this is pertinent or helpful on any SAN, but specifically a Netapp.</P><P></P><P>thx,</P><P>Randy</P></BODY></HTML> Thu, 05 Jun 2025 07:11:29 GMT indianrock 2025-06-05T07:11:29Z SQL Server Instant File Initialization https://community.netapp.com/t5/Data-Protection/SQL-Server-Instant-File-Initialization/m-p/49224#M9449 <HTML><HEAD></HEAD><BODY><P>I'm trying to get a definitive answer as to whether this feature has any value when sql server data is stored on a Netapp device.&nbsp; If you turn this feature on in Windows Server, when SQL Server needs new disk space for a growing data file, it does not have to "zero out" the new space but puts the new space into use immediately.&nbsp;&nbsp; I'm getting different answers as to whether this is pertinent or helpful on any SAN, but specifically a Netapp.</P><P></P><P>thx,</P><P>Randy</P></BODY></HTML> Thu, 05 Jun 2025 07:11:29 GMT https://community.netapp.com/t5/Data-Protection/SQL-Server-Instant-File-Initialization/m-p/49224#M9449 indianrock 2025-06-05T07:11:29Z Re: SQL Server Instant File Initialization https://community.netapp.com/t5/Data-Protection/SQL-Server-Instant-File-Initialization/m-p/49228#M9450 <HTML><HEAD></HEAD><BODY><P>Article on this here. Anyone else using a Netapp behind sql server?</P><P></P><P><A href="http://www.sqlservercentral.com/blogs/aloha_dba/archive/2010/7/21/instant-file-initialization-speeds-sql-server.aspx" target="_blank">http://www.sqlservercentral.com/blogs/aloha_dba/archive/2010/7/21/instant-file-initialization-speeds-sql-server.aspx</A></P></BODY></HTML> Tue, 27 Jul 2010 12:01:24 GMT https://community.netapp.com/t5/Data-Protection/SQL-Server-Instant-File-Initialization/m-p/49228#M9450 indianrock 2010-07-27T12:01:24Z