Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NonStopMark
Starting Member
1 Post |
 Posted - 2011-03-03 : 03:36:28
|
| HelloI am currently looking to purchase Microsoft SQL Server 2008 (Enterprise Edition) but before I do, I would like to know what the maximum number of rows is, that can be stored in a partitioned SQL table (and non-partitioned for my understanding and completeness). I have read on more unofficial internet MS SQL sources, that you are limited only by the storage hardware available to you. Is this correct? Finding an answer to this question is not that easy (on the internet at least).I am looking to store (and query on) up to 40 terabytes of transaction data (20,000 million rows approx.) in 2 SQL tables (partitioned of course) which equates to 20 years of data.Can this be done in Microsoft SQL Server 2008? If this answer is ‘yes’, can any recommendations be made regarding common sense approach, storage hardware required and D/R contingency measures for this size of database...Thanks in advanceMark.www.markwhitfield.net |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-03-03 : 11:21:13
|
| 40TB is quite large, but yes SQL Server 2008 Enterprise Edition can handle this, assuming it's properly designed. I'd likely split this out to at least two databases, one for historical and one for the stuff that is "current" or more frequently queried. If the historical data isn't going to change, you can make it read-only and do some fancy stuff to it to make it super fast.For DR, I'd recommend asynchronous database mirroring. If you can wait until Denali is released, the mirroring feature is vastly improved although it's still a great product in 2005/2008.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-03 : 11:34:42
|
| There's a presentation by the SQLCAT team that discusses the largest SQL Server installations: http://bit.ly/aNg6lZThey have customers with >40 TB of data, but it's usually stored in multiple databases. You can find more information on their website: http://sqlcat.com/ |
|
|
|
|
|
|
|
|
Maximum number of rows in 'Partitioned' SQL table