Specifies the maximum amount of memory allocated for the dynamic calculator cache.
This setting does not apply to aggregate storage databases.
DYNCALCCACHEMAXSIZE [appname [dbname]] n
|appname||If you supply an application name, the setting applies to all databases within the application. If you do not supply an application name, the setting applies to all applications and databases on the server.|
|dbname||If you supply a database name, the setting applies only to the database. If you do not also provide an application name, the setting applies to all applications and databases on the server|
This setting specifies, in bytes, kilobytes, megabytes, or gigabytes, the maximum amount of memory that Analytic Services can allocate for the dynamic calculator cache for each database. The specified value takes effect for all databases that are opened after the server is started.
The dynamic calculator cache is a memory buffer that holds data blocks that are expanded to include dynamically calculated members. Analytic Services allocates memory in the dynamic calculator cache to store these blocks during retrievals or calculations that involve dynamically calculated members.
Using dynamic calculator cache may improve retrieval performance by reducing the number of calls to the operating system to do memory allocations.
When the DYNCALCCACHEMAXSIZE setting is not equal to 0, you should also consider the following settings that affect how Analytic Services uses dynamic calculator cache:
causes Analytic Services to set 30 megabytes as the maximum size for the dynamic calculator cache.
Database Administrator's Guide