March 3, 2011 at 1:38 am
Hello
I 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 advance
Mark.
March 3, 2011 at 12:49 pm
http://msdn.microsoft.com/en-us/library/ms143432.aspx
here is limits of sql2008
March 3, 2011 at 12:54 pm
limited by 16 tb filegroups so you would have to divide it up
the row are limited by diskspace
http://msdn.microsoft.com/en-us/library/ms186981.aspx
bigger issue is 8060 by row size
March 3, 2011 at 5:47 pm
Even 16 TB is going to be very heavy. Please look into other stats b4 proceed with a huge data.
-Lucky
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply