All pages have a header that stores information, such as the partition ID that the page belongs to, and other information used to manage space on the page. Table 2-1 shows the number of bytes of overhead and usable space on data and index pages for a server configured for 2K pages.
Locking Scheme |
Overhead |
Bytes for user data |
---|---|---|
Allpages |
32 |
2016 |
Data-only |
46 |
2002 |
The rest of the page is available to store data and index rows.
For information on how text, image, and Java columns are stored, see “Large object (LOB) pages”.