Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Tempdb in sql server 2005 Expand / Collapse
Author
Message
Posted Thursday, October 21, 2010 5:11 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, October 20, 2012 10:01 PM
Points: 76, Visits: 282
Hi

what is maximum size of temp db?

Subha
Post #1008330
Posted Thursday, October 21, 2010 5:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 22, 2014 3:23 AM
Points: 112, Visits: 297
It can't get any larger than the disk array(s) it is placed on.
Post #1008332
Posted Thursday, October 21, 2010 5:35 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:07 AM
Points: 39,975, Visits: 36,331
Same as any other database

A little over 500 000 TB.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1008349
Posted Wednesday, October 27, 2010 3:27 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:01 AM
Points: 2,840, Visits: 3,968
subha.mcts2005 (10/21/2010)
what is maximum size of temp db?
Seems like interview question ?


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1011349
Posted Wednesday, October 27, 2010 3:48 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, October 20, 2012 10:01 PM
Points: 76, Visits: 282
yes..

plz Explain It ?

Subha

Post #1011355
Posted Wednesday, October 27, 2010 3:55 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
the max capacity for sql server can be found here

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..
Post #1011358
Posted Wednesday, October 27, 2010 4:04 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:07 AM
Points: 39,975, Visits: 36,331
Already did.

GilaMonster (10/21/2010)
Same as any other database

A little over 500 000 TB.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1011365
Posted Wednesday, October 27, 2010 4:30 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, October 20, 2012 10:01 PM
Points: 76, Visits: 282
thanks very one...

its good......
Post #1011382
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse