Calculating heap memory

To calculate how much heap memory Adaptive Server sets aside, perform the following (Adaptive Server reserves a small amount of memory for internal structures, so these numbers vary from site to site):

((1024 * 1024) + (heap memory in bytes)* (number of user connections + number of worker processes) )

The initial value of (1024 * 1024) is the 1MB initial size of the heap memory pool. Adaptive Server reserves a small amount of memory for internal structures.

For example, if your server is configured for:

• heap memory per user – 4K

• number of user connectins – 25 (the default)

• number of worker processes – 25 (the default)

@@heapmemsize reports 1378304 bytes.

And the estimated value using the formula above, is:((1024 X 1024) + (4 * 1024 * 50)) = 1253376

Now, if you increase the number of user connections, the size of the heap memory pool increases accordingly:

sp_configure 'user connections', 100

@@heapmemsize reports 1716224 bytes.The estimated value in this case comes out to be:((1024 * 1024) + (4 * 1024 * (100 + 25) ) = 1560576

If your applications were to fail with the following error message:

There is insufficient heap memory to allocate %ld bytes. Please increase configuration parameter 'heap memory per user' or try again when there is less activity on the system.

You can increase the heap memory available to the server by increasing one of:

• heap memory per user

• number of user connections

• number of worker processes