Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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?
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
