Estimating Startup Memory Requirements for Databases

Calculate memory requirements for each database on Essbase Server.

For each database, make a copy of Table 250 or use a separate sheet of paper as a worksheet for one database. If multiple databases are on Essbase Server, repeat this process for each database. Write the database name on the worksheet.

Each row links to information that describes how to size that component. Perform each calculation and note the results in the appropriate cell in the Size (MB) column. Some calculations use the factors that you wrote in Table 249, Worksheet: Factors Used to Calculate Database Memory Requirements. After filling in all the sizes in the Size column, total them to determine the memory requirement for that database.

Table 250. Worksheet: Estimating Memory Requirements for a Database

Database Name:

Size (MB)

Memory Requirements:This image of a space is used for formatting purposes only.

This image of a space is used for formatting purposes only.
Startup requirements per database: 

Database outline

See Outline Size Used in Memory.

MA:

Index cache

See Sizing Caches.

MB:

Cache-related overhead

See Cache-Related Overhead.

MC:

Area for data structures

See Memory Area for Data Structures.

MD:

Operational Requirements:

 

Memory used for data retrievals

See Estimating Additional Memory Requirements for Data Retrievals.

ME:

Memory used for calculations

See Estimating Additional Memory Requirements for Calculations.

MF:

Total memory required for the database:

MA + MB + MC +MD + ME + MF

MG:

Total database memory requirement in megabytes (MB):

MG / 1,048,576 bytes

Write the name of this database and the total memory required in Table 252, Worksheet: Total Server Memory Requirement, which is a worksheet for determining the memory requirement for all databases on the server (there are placeholders for seven databases—“a” through “g”).

MH:

Repeat this exercise for each database on the server. After estimating the memory required for all databases on the server, proceed to Estimating the Total Essbase Server Disk Space Requirement.