October 21, 2010 at 5:11 am
Hi
what is maximum size of temp db?
Subha
October 21, 2010 at 5:12 am
It can't get any larger than the disk array(s) it is placed on.
October 21, 2010 at 5:35 am
Same as any other database
A little over 500 000 TB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2010 at 3:27 am
subha.mcts2005 (10/21/2010)
what is maximum size of temp db?
Seems like interview question ?:-D
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 27, 2010 at 3:48 am
yes..
plz Explain It ?
Subha
October 27, 2010 at 3:55 am
the max capacity for sql server can be found here
http://msdn.microsoft.com/en-us/library/ms143432.aspx"> http://msdn.microsoft.com/en-us/library/ms143432.aspx
Temp Db is like any other so the max size as mentioned would be 524,272 terabytes.
However in practice it would be a LOT less.
If this is an interview question, then it is a fairly bad one..
October 27, 2010 at 4:04 am
Already did.
GilaMonster (10/21/2010)
Same as any other databaseA little over 500 000 TB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2010 at 4:30 am
thanks very one...
its good......
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply