Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

What are the reasons a data file (8 GB) could take a long time to grow even if Instant file initialization is turned on in sql server 2008r2?

The sql service account has admin access to "Perform Volume Maintenance Tasks". It is supposed to be creating the data file immediately per the way IFI is supposed to work. Are there other tricks that one needs to be aware of before setting this and expecting the file growth to be instantaneous and does not cause performance issues.

share|improve this question
    
Have you restarted the SQL Server instance since you enabled this setting? –  mrdenny Jan 29 '13 at 6:53
    
@mrdenny - Yes the instance has been restarted. –  user65649 Jan 29 '13 at 16:38
    
Does the errorlog report that IFI is being used? –  mrdenny Jan 29 '13 at 20:29
    
@mrdenny - Sorry about the delay in responding. No records for IFI are getting logged to the error log (neither zeroing our of the log file nor the zeroing out of the data file). –  user65649 Feb 5 '13 at 22:09
    
You'll only see a message in the log when the instance is first starting up. –  mrdenny Feb 5 '13 at 22:14
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.