Estimating Additional Memory Requirements Without Monitoring Actual Queries

If you cannot perform this test with actual queries, you can calculate a rough estimate for operational query requirements. Requirements for each retrieval vary considerably. Generally, this estimate uses the following fixed factors:

This estimate also uses the following variables:

You can then use the following two calculations for the memory needed for retrievals:

Summarize the calculations and write the result, in bytes, to the cell labeled ME in Table 250, Worksheet: Estimating Memory Requirements for a Database.

Example

To estimate the maximum memory needed for concurrent queries, assume the following values for this example:

Estimated memory for retrievals:

184,000 bytes + (20 concurrent inquiries
* (10,240 bytes + 20,480 bytes + 144,000 bytes
+ 761,600 bytes + 3,145,728 bytes + 400,000 bytes))
= 75,824,960 bytes