![]() Large object data types: text, ntext, image, nvarchar(max), varchar(max), varbinary(max), and xml data. Page typeĭata rows with all data, except text, ntext, image, nvarchar(max), varchar(max), varbinary(max), and xml data, when text in row is set to ON. The following table shows the page types used in the data files of a SQL Server database. This information includes the page number, page type, the amount of free space on the page, and the allocation unit ID of the object that owns the page. Finally, there are system pages that store various metadata about the organization of the data.Įach page begins with a 96-byte header that is used to store system information about the page. The index pages contain index references about where the data is. Again, SQL Server is no different: most pages contain actual rows of data that were stored by users these are called data pages and text/image pages (for special cases). In a book, most pages contain the data - the main content of the book - and some pages contain metadata about the content (for example, the table of contents and index). Similar to a book, SQL Server writes all data rows on pages, and all data pages are the same size: 8 KB. In a regular book, all content is written on pages. That is, SQL Server reads or writes whole data pages.Įxtents are a collection of eight physically contiguous pages and are used to efficiently manage the pages. Disk I/O operations are performed at the page level. ndf) in a database is logically divided into pages numbered contiguously from 0 to n. The disk space allocated to a data file (.mdf or. The fundamental unit of data storage in SQL Server is the page. Understanding the architecture of pages and extents is important for designing and developing databases that perform efficiently. This guide describes the data structures that are used to manage pages and extents in all versions of SQL Server. An extent is a collection of eight physically contiguous pages. The page is the fundamental unit of data storage in SQL Server. Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) ![]()
0 Comments
Leave a Reply. |