All geek questions in one place

In SQL Server, how do you determine the number of rows per page?

In SQL Server, how do you determine (average or expected) the number of rows per page?

I know how to determine the average and maximum row size, but I do not know how this relates to the actual lines / page.

+3
source share
2 answers

8060 bytes per page, 8 pages per size ... remember that if you are in a line of 4040 bytes, you can only put one line per page

DBCC SHOWCONTIG will provide you with how many pages your table uses.

+4
source

Pages are 8K in size, including a 96 byte header. Therefore, if you know the size of the line, you can estimate how many lines will fit into the data part of the page.

0

Source: https://habr.com/ru/post/1702494/

More articles:


All Articles