May 26, 2010 at 1:35 pm
I'm working with some Contractors, and on one of the software packages we are installing I'm sizing the disks.
Some of the best practices documentation from Microsoft calls for the tempdb to be 20% of the size of the actuall DB the applications use.
We are looking at a db that will be over 2 TB, so if that is the case the TempDB will be sized at over 400 GB.
I understand what the TempDB can hold and sort, version store, indexing, yadda yadda yadda and it is quite versitile.
does anyone out there have VLDB experience that can say, "Yes, the TempDB can really get that big!"
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
May 26, 2010 at 2:52 pm
Bradley B (5/26/2010)We are looking at a db that will be over 2 TB, so if that is the case the TempDB will be sized at over 400 GB.
My personal experience...
2.4TB Data Warehouse,
45 Gig Temp space
...works just fine.
From time to time some query abends 'cause of lack of temp space - 100% of the time we find out it was a very baddly written query.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply