Skip to Content
0
Former Member
Apr 23, 2014 at 08:50 PM

Total memory calculation

137 Views

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???