INF: Text/Image Data Page Calculation Formula Is Wrong

ID: Q88489

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2

The "System Administrator's Guide" incorrectly states in Appendix A on page 250 a formula to calculate the number of text/image pages that will be used for a single entry. The documentation states:


   The text chains that store text and image data have 112 bytes of
   overhead per page. Use the following formula to calculate the
   number of text chain pages that a particular entry will use:

      Data Length / 1936 = Number of 2K Pages

This formula is incorrect. The actual maximum amount of data that can be stored on a text/image data page is 1800 bytes.

To correctly calculate the number of text chain pages that a particular entry will use, the formula should be:


   Data Length / 1800 = Number of 2K Pages

Additional query words: database size

Keywords : kbother SSrvServer
Version : 4.2
Platform : OS/2
Issue type :