Pre-size tempdb

Question

Pre-size tempdb

Tharg

SSC Eights!

Points: 980
More actions
February 11, 2010 at 12:00 pm

#215560

I'm reading "Storage Top 10 Best Practices" here: http://technet.microsoft.com/en-us/library/cc966534.aspx
"Make sure to move TEMPDB to adequate storage and pre-size after installing SQL Server."
What does pre-size refer to here?

Viewing 6 posts - 1 through 5 (of 5 total)

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

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 1

Create the temp database to the adequate size before use. Determine how large you need the Temp database to be, and then set the initial size to that, and set the expansion or how much to grow each time to a proper setting. you do not what the temp database to spend all it time growing to meet the needs if the percent to grow is set too small. It waste too much time doing that and not storing the temp work that the other databases pass to it

Andrew SQLDBA

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 2

Andrew has my advice, though if you're not sure, take a guess. Don't leave it at 1MB. I might go for 10% of largest main db size as a start.

Tharg SSC Eights! Points: 980 More actions · Answer 3

Thanks for replies 🙂 Is "post-sizing" possible?

If my largest DB is 50GB, will re-sizing the tempdb to 5GB be beneficial?

GTR SSCrazy Eights Points: 8007 More actions · Answer 4

If possible use separate data drive for Temp DB data and log files.

EnjoY!

EnjoY!

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 5

You can always resize if you need it. If your tempdb is not growing often, you should be OK.

It's the growing that's an issue, not the size.