What are the components of SQL Server architecture?

What is SQL Server database architecture?

SQL Server database is a logical collection of data. Data is stored in two sets of files - Data Files and Log Files. An Extent consists of 8 - 8KB continuous pages and in similar manner the data file consists of extents. Log files store all modifications that are made to the database such as DDL, DML operations.

What are the main components of a SQL query?

SQL has three main components: the Data Manipulation Language (DML), the Data Definition Language (DDL), and the Data Control Language (DCL).

What are the components of SQL Server Agent?

Typical system tasks performed include scheduling maintenance plans (such as backups), handling Reporting Services subscriptions and performing log shipping sub-tasks (backup, copy, restore & check). User tasks, such as scheduling some T-SQL or command line statement are also common.

What is the architecture design in SQL?

We have classified the architecture of SQL Server into the following parts for easy understanding − General architecture. Memory architecture. Data file architecture. Log file architecture.