Can SQL Server 2000 support how big databases? Do you do tens of GIGA? When the amount of data is large (tens of giga), is the speed of SQL Server 2000? When there are millions of row of data in a table, will SQL Server 2000 query speed will be very slow? Can SQL Server 2000 be a cluster? Can you do load balancing? Is the cluster of SQL Server 2000? Will MSCS will collapse often? Can SQL Server 2000 can be used for critical applications? How is the performance and reliability of the PC server and RS6000 or Linux? ......
There are still many similar problems. For these problems, as a loyal buttons of SQL Server 2000, my answer is of course positive, affirmative. But I have been working hard to find a good material that is used to agree: Although the third party has a TPC evaluation result, there is a successful case in the company, there are many technical information on the Internet, but it always feels not to respond to these questions. Too much, not straightforward. Some white paper is how to configure the cluster, some is how to do performance tuning, some is how to use Analysis Service, but I have not answered it on the point.
Today, this article is finally answering to the idea, so be sure to recommend: "SQL Server large server: scalability, availability and easy management". Several feelings: content is very refined, all useful content, some data, inductive, have not seen or no one has been sorted out, the content is very complete, almost all question can find a solution. Just this article is a little old, and it is also mentioned that Oracle Parallel Server is already RAC, so this article does not mention the debate between the Oracle Rac and SQL2K's Cluster.
Don't say anything, take care of your heart: http://www.microsoft.com/china/technet/ProdTechnol/SQL/2000/PLAN/ssmsam.mspx
