Databases Reference
In-Depth Information
•
INDEXCACHESIZE
: This sets the index cache size for all of the new databases
that are created on the server. This cache holds the index pages in the
memory. The index cache size can also be specified in Bytes (B), Kilobytes
(K), Megabytes (M), or Gigabytes (G). Again, this setting will take effect
after the analytic service is restarted or after a server reboot.
Syntax:
INDEXCACHESIZE n
n is an integer value in B, K, M, or G
Code Sample:
INDEXCACHESIZE 400M
This sets the index cache size to 400 Megabytes for all new databases that
are created after the service is restarted.
Well, that wraps it up for the system memory and its management. We know
you've heard this before, but here it goes. Always buy the most memory you can
afford at the time you are purchasing it. If you believe you will do fine with 32 GB,
then buy 64GB.
Summary
Goodness, you must be an Essbase expert by now! No, there is no such thing
as an Essbase expert. In real life, maybe an Essbase Guru would most accurately
describe someone who is more proficient with Essbase than others.
By now, we believe that you now realize that Essbase is not all about reading
and memorizing recommended settings and sizes, but instead Essbase is more
about using what resources you have available to you to get the job done. A Guru
is someone who possesses far more than just the so-called technical knowledge.
A Guru is also someone who possesses intelligence and wisdom.
Yes, someone could create a test for Essbase to gauge your overall technical
knowledge, but what really counts is your good judgment based on your experience.
Figuring out how to accomplish the same task several different ways based on the
situation is how you advertise your Essbase Guru-ability (is that even a word).
Here is an example of Essbase Guru-ability. Consider that you are a reasonably capable
technical person who now has Essbase knowledge added to his repertoire of skills. You
are performing a large data load from a relational database (we're talking Gigabytes). It
seems like the load is taking much too long to complete. What do you do?
