Sql Server Architecture

SQL Server 2005 architecture is collection of components like pages, extents, tables, indexes, query processor and internal memory structure etc. These sql server components works together to maintain data as per customer requirement.

SQL Server architecture is divided into Physical Database Architecture and Relational Database Engine Architecture

Physical Database Architecture

Physical database architecture is collection various logical components that will tell you how they are implemented in database files.
Logical Components of database architecture

Page and extents: it will give you information related data storage architecture.

Physical database file and file groups: Gives you the Information about default physical database and log file location.

Space Allocation and reuse: Gives you the information related to space allocation and internal process communication to work together for performance improvement.

Table and index Architecture: This will tell how pages of table and indexes are organized in sql server database.

Transaction log architecture: Internal structure of log that will tell you how transaction logs are used in sql server database to keep database consistent.

Relational Database Engine Architecture

Relational database engine handles multiple requests for data from many users and makes processing efficient. SQL Server 2005 database engine is core component which plays most important role in data handling. Data storing, processing and securing is the core feature of Microsoft SQL Server 2005 Database Engine.

The Database Engine provides access to control oltp transaction processing to meet the requirements of large applications within organization.
Whenever request sends by client using sql statements, Sql server database engine receives those requests and process them to complete transaction.

Leave a Reply




− 2 = 6