IFI - instant file initialization?

Hi experts
1. When should I use IFI - instant file initialization?
2. Some URL that I can recommend for the implementation
3. Should I have it configured because it helps in the autogrowth?
enrique_aeoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott PletcherSenior DBACommented:
1. Unless you have security issues that prevent it, you should always use IFI

2. Not sure what you mean.  If you mean justification for using it, MS has some documentation on why it should be used except for security issues.

3. Yes.
0
enrique_aeoAuthor Commented:
1. What security problem could it have?
0
Scott PletcherSenior DBACommented:
IFI means the new disk space allocated is not writen over.  In theory, someone could look at the physical file and see data that was there from the previous file that used that disk space.  It's a rather obscure risk.  Unless you have credit card info or SSNs or some other really sensitive data that's not encrypted stored in a table, I wouldn't worry about it too much.
0
enrique_aeoAuthor Commented:
i do not understand
In theory, someone could look at the physical file and see data that was there from the previous file that used that disk space
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
First, IFI is applicable only for Data files and not for Log files.
Whenever IFI is enabled, SQL Server can expand the data files or create data files instantly without writing zeroes in the file system(you can assume it as formatting with zeroes so older files/folder can't be accessible).
>> 1. When should I use IFI - instant file initialization?
If you have huge databases with autogrowth value of data files say 4GB or more, then IFI can help expand the files faster.

>> 2. Some URL that I can recommend for the implementation
Some good URL's to start are..
https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-instant-file-initialization?view=sql-server-2017
https://www.brentozar.com/blitz/instant-file-initialization/

>> 3. Should I have it configured because it helps in the autogrowth?

As mentioned earlier, if the database size is really huge or if the autogrowth values are really huge..
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.