February 11, 2010 at 12:00 pm
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?
February 11, 2010 at 1:15 pm
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
February 11, 2010 at 1:26 pm
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.
February 11, 2010 at 1:36 pm
Thanks for replies 🙂 Is "post-sizing" possible?
If my largest DB is 50GB, will re-sizing the tempdb to 5GB be beneficial?
February 11, 2010 at 1:39 pm
If possible use separate data drive for Temp DB data and log files.
EnjoY!
February 11, 2010 at 1:45 pm
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.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply