Total memory calculation

[Former Member]

Search over internet and get one calculation on memory request:

Total Memory =

Dataserver Executable Size (in bytes) +

Static Overhead of 1 Mb +

User Connections x 40,960 bytes +

Open Databases x 644 bytes +

Locks x 32 bytes +

Devices x 45,056 bytes

Procedure Cache +

Data Cache

don't understand this in detail.

Dataserver Executable Size (in bytes) +   ----how to get this ???

Static Overhead of 1 Mb +                   ---how to calc this???

User Connections x 40,960 bytes +     ---can get this from server param: number of user connections

Open Databases x 644 bytes +           ---can get this from server param: number of worker processes

Locks x 32 bytes +                            -----can get this from server param: number of locks???

Devices x 45,056 bytes +                   ----number of devices???

Procedure Cache +                            ---20% of data cache???

Data Cache                                       --- decided by app???

[Former Member]

Hi Kent,

> Dataserver Executable Size (in bytes) +   ----how to get this ???

> Static Overhead of 1 Mb +                   ---how to calc this???

Why do you need the exact size of the dataserver executable. This size will change which every new version of the binaries that you would use.

The best way to check the size of the memory requirements for ASE is to set up the 'max memory' variable. This setting will set the upper limit for the memory allocation in ASE.

The easiest way to check what is the current memory usage by running

sp_configure 'total logical memory'

More details are here:

How much memory to configure

All the other parameters are also set by sp_configure.

When you add some memory to some functionality, the remaining memory from (max memory - total logical memory) will decrease.

> Locks x 32 bytes +                            -----can get this from server param: number of locks???

correct

>Devices x 45,056 bytes +                   ----number of devices???

correct

> Procedure Cache +                            ---20% of data cache???

incorrect

The procedure cache is set up by 2k page size

sp_configure 'procedure cache size'

> Data Cache                                       --- decided by app???

This is the sum of all your data cache:

sp_cacheconfig will give you a summary

HTH,

Adam