September 14, 2009 at 7:06 pm
I have complied the list of Maximum Capacity Specifications for SQL Server with versions from SQL Server 7.0 to SQL Server 2008. The file is attached. I took the initial list created by Steve Jones and added the information to it. The link is http://www.sqlservercentral.com/articles/Administration/maximumcapacityspecificationsinsqlserver2005/1574/
There are few bits missing in the list which i couldn't find in msdn. If anybody is aware of it please let me know.
Also i found that maximum database size is reduced in newer versions of SQL server as compared to old versions. In SQL Server 7.0 and 2000, the max db size was 1,048,516 terabytes where as in SQL Server 2005 and later have 542,272 terabytes. I haven't heard of and cant imagine a single database of even 542,272 terabytes, but isn't it a degradation.
September 14, 2009 at 7:58 pm
Wow, somehow I just don't see 542,272 terabytes as a major limitation.. I'd like to hear from a single site that has a database that big.. I'd really like to see their backup strategy..
CEWII
September 14, 2009 at 9:14 pm
You are right Elliott, any single database more than 50 TB is of interest to me as well. I haven't heard of this much big single database (500K TB) in production environment. The only example I can think of at the moment could be of stock exchange. It would be interesting to know what problems they face in day to day DBA tasks.
Any gurus who have worked in really large environments, please shed some light here.
September 14, 2009 at 9:18 pm
I would love to see the maintenance strategies for something like this..
CEWII
September 14, 2009 at 10:05 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply