x

TempDB Initial Size

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.

more ▼

asked Oct 03, 2013 at 07:24 PM in Default

avatar image

sfar
30 1 1 3

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Oct 03, 2013 at 07:35 PM

avatar image

Tim
40.9k 39 95 168

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x79

asked: Oct 03, 2013 at 07:24 PM

Seen: 1077 times

Last Updated: Oct 03, 2013 at 07:35 PM

Copyright 2018 Redgate Software. Privacy Policy