Saturday, June 18, 2011

Instant File Initialization

Instant File Initialization in SQL Server 2005/2008 is an easy performance win for the SQL DBA.  This feature allows SQL Server to allocate space (only data not log space) much quicker.   Besides making initial database creation faster, it has the advantage of increasing the size of database data files much faster as well.  This is an operational win with little downside.

Kimberly Tripp has an excellent blog on using this feature.   Paul Randall has a great follow-up in his blog where his dispels some common myths about instant file initialization. 


No comments:

Post a Comment