Tuesday, August 31, 2010

Instant File Initialization for SQL Server 2005/2008

This article discusses Database Instant File Initialization, which instructs the OS to allocate the required disk space immediately before actually zero-ing out the content from the allocated space. This means the content of the allocated disk area remains there until SQL overwrites it, improving the performance and reducing the downtime. Read on to learn more...

No comments:

Post a Comment