I know several factors play a role in sizing up the TempDB. But what is the general rule of thumb for the ratio of the Tempdb 'initial' size to the size fo the UserDB? (Our Sqlserver 2005 Production UserDB size is 30 GB. What is the least TempDB intial size value we could use?) Thanks.
asked Oct 03, 2013 at 07:24 PM in Default
What is the size of your largest table in the 30 GB db. You would want to account for the rebuild of that clustered index and go 1.25 to 1.5 that size. Also consider the number of physical cores you have for the number of tempdb data files you need and how many NUMA nodes.
But yes lots of other factors such as ETL process creating temp space etc. The only real way to know is let it grow and resize accordingly.
Also don't forget about Instant File Initialization.
answered Oct 03, 2013 at 07:35 PM