|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Today @ 1:12 PM
Points: 38,062,
Visits: 30,355
|
|
Are you sure it's TB, not GB? A log file cannot be bigger than 2TB.
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
|
|
|
|
|
SSChampion
        
Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 13,436,
Visits: 25,281
|
|
|
|
|
|
Old Hand
      
Group: General Forum Members
Last Login: Today @ 6:56 AM
Points: 365,
Visits: 2,912
|
|
Grant Fritchey (4/29/2010) If this turns out to be gigs, I'm going to cry. I was terribly excited about an 800TB system.
Me too.
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Monday, May 06, 2013 4:10 PM
Points: 1,053,
Visits: 6,426
|
|
My bet is on GB's not TB.
------------------------------------------------------------- "It takes 15 minutes to learn the game and a lifetime to master" "Share your knowledge. It's a way to achieve immortality."
|
|
|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: Monday, June 10, 2013 8:14 AM
Points: 961,
Visits: 797
|
|
Aside from the fact that the largest size of a DB os 500TB, assuming you even had something that large.
How Many: Teamed Network Cards? HBA Controllers? Drives (Max MDF file is on 16TB)
What server could handle 25 1GB network cards and 50 controller's?
How much total SAN space does the enterprise have? Few places have 1 PB of SAN Space just for data, let alone backups.
It could not be backed up over copper, fibre would still be very time consuming, even with the best router?
You could never DR it, the amount of time to logship/mirror multiple T3's would be very long...plus you would need that much space at the DR side.
I'm sure it's 800GB, but it's interesting to think of it it could be 800TB. However, I think given a max DB size of 500TB, he has to mean 800GB
/* ----------------------------- */ Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252,
Visits: 3,367
|
|
|
|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Today @ 1:12 PM
Points: 38,062,
Visits: 30,355
|
|
GregoryF (4/29/2010) Are you really sure it's 800TB and not 800GB?
SQL 2008 only support 512TB Databases http://msdn.microsoft.com/en-us/library/ms143432.aspx
So does SQL 2005 http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx
No. Not 512 TB. 524,272 TB. 524 PB (petabytes)
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
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252,
Visits: 3,367
|
|
GregoryF (4/29/2010) Are you really sure it's 800TB and not 800GB?
SQL 2008 only support 512TB Databases http://msdn.microsoft.com/en-us/library/ms143432.aspx
So does SQL 2005 http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx
No SQL Server supports over 512 TB, take a look more closely, the MAX spec. is 524272 TB (that's means in Peta Bytes)! So if the situation is true, it can be !
============================================================ SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION = http://www.sqlservercentral.com/articles/Best+Practices/61537/
|
|
|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: Monday, June 10, 2013 8:14 AM
Points: 961,
Visits: 797
|
|
Dugi (4/29/2010)
GregoryF (4/29/2010) Are you really sure it's 800TB and not 800GB?
SQL 2008 only support 512TB Databases http://msdn.microsoft.com/en-us/library/ms143432.aspx
So does SQL 2005 http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspxNo SQL Server supports over 512 TB, take a look more closely, the MAX spec. is 524272 TB (that's means in Peta Bytes)! So if the situation is true, it can be ! 
Thanks, I did not notice the factor of 100, I'm not used to files of such size...
But with a 16TB limit on datafiles, you would still need 50 datafiles. With a limit of 2TB on logs, 50 logs. That's an unrealistic number of drives with corresponding HBA cards. And both of those numbers assume that all files are at 100%.
The server that could process all of this, and the SAN that could store it, and the networking that can transfer it, would out of reach for all but the richest of companies.
If it's true, I'd love to play with it
/* ----------------------------- */ Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Friday, June 14, 2013 4:16 AM
Points: 1,121,
Visits: 1,410
|
|
Steve Jones - Editor (4/29/2010)
Also, I'm curious how you are backing up the log every 10 sec. Are you using some external program. AFAIK, jobs to schedule can be done every minute, not more granular than that.
2008 can indeed go down to seconds, but I can't say I had noticed it before.
|
|
|
|