SQL Server Architecture
SQL Server Architecture Overview
Microsoft® SQL Server™ 2000 is a set of components that work together to meet the data storage and analysis needs of the largest Web sites and enterprise data processing systems. The topics in SQL Server Architecture describe how the various components work together to manage data effectively.
| Topic | Description |
|---|---|
| Features of SQL Server 2000 | Highlights the features of Microsoft SQL Server 2000. |
| Relational Database Components | Describes the main relational database components of SQL Server 2000, including the database engine itself and the components involved in communications between applications and the database engine. |
| Database Architecture | Describes the logical components defined in SQL Server databases and how they are physically implemented in database files. |
| Relational Database Engine Architecture | Describes the features of the server engine that make it efficient at processing large numbers of concurrent requests for data from many users. |
| Administration Architecture | Describes how the easy-to-use tools provided with SQL Server 2000 and the dynamic configuration capabilities of SQL Server minimize routine administrative tasks. |
| Replication Architecture | Describes the replication components of SQL Server 2000 and how they can be used to distribute data between databases. |
| Data Warehousing and Online Analytical Processing | Describes Data Transformation Services (DTS) and Microsoft SQL Server 2000 Analysis Services, and how they help in building and analyzing a data warehouse or data mart. |
| Application Development Architecture | Describes how SQL Server 2000 supports the various database programming APIs, which allow users to build robust database applications. |
| Implementation Details | Provides implementation details, such as the maximum capacities of Transact-SQL statements, the ranges of SQL Server configuration options, memory usage of SQL Server objects, and the differences among the editions of Microsoft SQL Server. |