Answers

Question and Answer:

  Home  MS SQL Server Architecture

⟩ Please illustrate physical database architecture?

The physical database architecture describes how the database and files are organized in a SQL server.

Pages and extents: these describe how the data is stored

Physical Database Files and File groups :- describes the operating system files used to store data and logs.

Space Allocation and Reuse :- Describes the algorithms used for space allocation.

Table and Index Architecture :- Describes the way pages for tables can be indexed

 158 views

More Questions for you: