Database Instant File Initialization

Question

Database Instant File Initialization

sql.monk

Mr or Mrs. 500

Points: 570
More actions
April 15, 2016 at 10:30 am

#326449

Hi team ,
Can anyone help me to understand in deep the advantages and disadvantages of Database Instant File Initialization .
Should i enable it if not there or disable it if there ..!!
Just wanted to know what actually Database Instant File Initialization does ...IS it anything related to Database file (.mdf file) growth ?
Thanks in advance
SQLMONK

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

r.dragoi-1095738 SSCrazy Points: 2022 More actions · Answer 1

Hi,

There is a nice article here : http://www.sqlpassion.at/archive/2014/02/18/improving-sql-server-performance-by-using-instant-file-initialization/

Cheers,

Robert

sql.monk Mr or Mrs. 500 Points: 570 More actions · Answer 2

r.dragoi-1095738 (4/19/2016)
Hi,
There is a nice article here : http://www.sqlpassion.at/archive/2014/02/18/improving-sql-server-performance-by-using-instant-file-initialization/
Cheers,
Robert

Let me check it .

Thanks Robert