Databases Reference
In-Depth Information
Its better to look at the real screen for yourself through the EAS. When it comes
to performance tuning, the settings on this screen will be invaluable!
Caches tab
Correctly set caches can make the difference between your business partner wanting
to fire you or wanting to adopt you. We will discuss these important settings later on,
but for now, just know that the default settings will be adequate for most moderate
sized cubes with moderate sized calculation or reporting needs.
One suggestion on caches, unless you are using the direct I/O data load option
which we will discuss in detail later, is to
never
check the
Cache memory locking
option . The
Cache memory locking
option locks the maximum amount of memory
for each cache, whether the database uses it or not. If your system is running that
close to maximum capacity, you better purchase some more memory in a hurry!
