Sql server tempdb data and log initial file size is configurable.

Assuming I set it to large values (say 10GB) then will sql server take more time to start compared to if the data/log initial file size were small (100MB)?

I'm asking because during sql installation it says the larger the tempdb data file initial size the longer it takes for installation. Does this also apply to sql service startup?


1 Answer 1


It depends on the Instant File Initialization. Tempdb is recreated all at once at each sql server restart.

To ensure fast tempdb (and other database too) creation, enable Instant File Initialization granting perform volume maintenance tasks to the sql server service account.


However, for large log files, you have to wait its creation based on your disks performance, as log files are not affected by Instant File Initialization


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.