Summary Microsoft SQL Server has developed into support giant databases and applications, including a few-million people who are available for millions of people. SQL Server supports upward extensions on a symmetrical multiprocessor (SMP) system (allowing users to add resources such as processors, memory, disk, network bandwidth to establish single large nodes) or outward into multi-node clusters (allowing giant databases The server cluster is partitioned, and each server stores a portion of the entire database and completes some of the work, ensuring that the database provides access to an overall form to access this scaling capacity. By expanding outward, SQL Server 2000 creates top-level performance indicators that have not been achieved in any database system in any platform in any platform in the transactional committee benchmark C (TPC-C).
The .NET server provides a high availability and automatic management mechanism with the SQL Server cluster. SQL Server supports high availability through built-in failover and replication technology. At the same time, SQL Server also provides a powerful management model based on user interface, wizard program, repetitive task job scheduling, and SQL-DMO-oriented application operations. The architecture of SQL Server is suitable for modular growth, automated configuration, maintenance, and programming implementation of large server areas.
http://www.microsoft.com/china/technet/Prodtechnol/SQL/2000/play/ssmsam.mspx#egaa
