Saturday, February 25, 2012

Articles on SQL Server capacity

I have been doing some reading for a project comparing various RDBMS and I
have read that SQL Server is not very stable for DBs over 300GB but I have
also read about terrabyte-plus databases running just fine. Are there any
recommendations or articles from Microsoft about the capacity of SQL Server
(2000 or 2005)?Hi
Probably you can check this:
http://chanduas.blogspot.com/2005/05/maximum-capacity-specifications.html
please let me know if you have any questions
--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Robert Kinesta" wrote:
> I have been doing some reading for a project comparing various RDBMS and I
> have read that SQL Server is not very stable for DBs over 300GB but I have
> also read about terrabyte-plus databases running just fine. Are there any
> recommendations or articles from Microsoft about the capacity of SQL Server
> (2000 or 2005)?|||> I have read that SQL Server is not very stable for DBs over 300GB
Sounds like either advocacy or marketing misinformation. I have worked
on and know of many SQL Server databases that are much larger. Equally,
bad design or improper hardware can defeat a database of any size.
Take a look at:
http://www.microsoft.com/sql/techinfo/administration/2000/scalability.mspx
--
David Portas
SQL Server MVP
--

No comments:

Post a Comment