Summary information |
|
|---|---|
Default value |
0 |
Range of values |
0 – 2147483647 |
Status |
Calculated |
Display level |
Basic |
Required role |
System administrator |
Configuration groups |
Cache Manager, Memory Use |
total data cache size reports the amount of memory, in kilobytes, that is currently available for data, index, and log pages. This parameter is a calculated value that is not directly user-configurable.
The amount of memory available for the data cache can be affected by a number of factors, including:
The amount of physical memory available on your machine
The values to which the following parameters are set:
total logical memory
number of user connections
total procedure cache percent
number of open databases
number of open objects
number of open indexes
number of devices
A number of other parameters also affect the amount of available memory, but to a lesser extent.
For information on how Adaptive Server allocates memory and for information on data caches, see “Configuration parameters”.
