Check for Instant File Initialization

Posted by TiborKaraszi on SQL Blog See other posts from SQL Blog or by TiborKaraszi
Published on Wed, 30 Oct 2013 15:12:00 GMT Indexed on 2013/10/30 16:05 UTC
Read the original article Hit count: 191

Filed under:
Instant File initialization, IFI, is generally a good thing to have. Check out this earlier blog post of mine f you don't know what IFI is and why it is a good thing: blog . The purpose of this blog post is to provide a simple script you can use to check if you have IFI turned on. Note that the script below uses undocumented commands, and might take a while if you have a large errorlog file... USE MASTER ; SET NOCOUNT ON -- *** WARNING: Undocumented commands used in this script !!! *** -- --Exit...(read more)

© SQL Blog or respective owner

Related posts about Performance