Tag Archives: Instant File Initialization

Turn on Instant File Initialization for SQL Server Performance – With Video Demo

Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or has to grow in size, the file or portion of the file added must be zeroed out.  Depending on the … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication | Tagged , | 9 Comments