Databases Reference
In-Depth Information
One of the single largest users of system memory is the database
outline itself. By its very nature, the larger the outline, the more
server memory is consumed just to load the database into memory.
We highly advise using extreme care in determining the data
elements and data categories you will use for your database outline.
Fewer dimensions are always preferable to more dimensions. For
every new dimension in the outline the potential size of the data and
the actual size of the outline grow exponentially. It is always better to
have fewer dimensions with lots of members, than it is to have more
dimensions with less members. Think about it!
essbase.cfg memory settings
Let's now take a look at those
essbase.cfg
memory specific settings that will
directly affect the performance of your Essbase system:
•
MULTIPLEBITMAPMEMCHECK
: Tells analytic services to enforce the size limit
for the amount of memory that is used for the calculator cache when analytic
services selects the multiple bitmap cache option.
•
VLBREPORT
: Tells Essbase to dynamically determine the retrieval buffer
size, between 100KB and 10MB, for retrievals from databases without
Dynamic Calc, Attribute, or Dynamic Time Series members. This memory
is only used when needed, so it does not take away from continuous
system resource availability.
•
TRIGMAXMEMSIZE
: This setting tells Essbase how much memory it can use to
perform the trigger function. While the triggering function is a great feature,
it can be very memory intensive at the expense of other system operations.
This memory is reserved by the application that has the trigger set up and is
no longer available to the rest of the server.
•
SSPROCROWLIMIT
: Controls the maximum number of spreadsheet rows
analytic services processes on an individual user spreadsheet request from
Microsoft Excel. The default is 250,000, which is extraordinarily high for
a spreadsheet request. You do not want a spreadsheet retrieval slowing
down your entire server, so we recommend starting with 5,000 rows, and
increasing as needed from there.
