All of the features and components of Microsoft® SQL Server™ work together to increase its effectiveness as an SQL-based, client/server, relational database. The topics in SQL Server Architecture describe how the various components work together to manage data effectively.
| Topic | Description |
|---|---|
| SQL Server Features | Highlights the features of SQL Server. |
| Client/Server Architecture | Describes the components involved in the communications between client applications and SQL Server. |
| Database Architecture | Describes the logical components defined in SQL Server databases and how they are physically implemented in database files. |
| Server 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 and the dynamic configuration capabilities of SQL Server minimize routine administrative tasks. |
| Replication Architecture | Describes the replication and data transformation services (DTS) components of SQL Server and how they can be used to distribute data between databases, such as when building a data warehouse system. |
| Data Warehousing and Online Analytical Processing | Describes Data Transformation Services (DTS) and Microsoft SQL Server OLAP Services, and how they help in building and analyzing a data warehouse or data mart. |
| Application Development Architecture | Describes how SQL Server supports the various database programming APIs to let users build robust database applications. |
| Implementation Details | Discusses 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 between the various editions of SQL Server. |