top of page

Instant File Initialization

  • Adam Thurgar
  • Feb 26, 2018
  • 1 min read

When doing system health checks I still see a number of systems that are not using Instant File Initialization (IFI). This feature of SQL Server, can provide significant performance improvement for operations that require an increase in the size of data files, such as database creation, restore, and file growth. Without IFI enabled, zeroes have to be written into the newly allocated file space, which is a time-consuming operation. With IFI enabled, space is allocated to the file, but zeroes are not written.

The requirements to enable IFI are in the following link.

https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-instant-file-initialization

Check your SQL Server to see if IFI is enabled and if not then work with you sysadmin to get it enabled.


 
 
 

Recent Posts

See All
Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a...

 
 
 
Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response...

 
 
 
Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete...

 
 
 

Comments


bottom of page