If a max_rows_per_page value is set for an allpages-locked table, the value is used to compute an expected row size during the alter table...lock command. The formula is shown in Table 9-7.
Value of max_rows_per_page |
Value of exp_row_size |
|---|---|
0 |
Percentage value set by default exp_row_size percent |
1-254 |
The smaller of:
|
For example, if max_rows_per_page is set to 10 for an allpages-locked table with a maximum defined row size of 300 bytes, the exp_row_size value will be 200 (2002/10) after the table is altered to use data-only locking.
If max_rows_per_page is set to 10, but the maximum defined row size is only 150, the expected row size value will be set to 150.
