Database Reference
In-Depth Information
7.1
Performance monitoring in HANA Studio
In order to effectively monitor the memory usage in your HANA system, you need to under-
stand some of the things that are happening behind the scenes. Memory in HANA is used in
a variety of ways.
1.
Operating system code and memory stack - this memory area is reserved for the
core computer code that manages all the operations within the HANA appliance.
This memory is reserved for HANA core processes and is not part of the memory
pool.
2.
System tables - these tables allow HANA to manage the complexities of an in-
memory database. They include joins, privileges, indexes, backup statistics,
memory maps, disk information, and much, much more.
3.
Row and column tables - these are the tables that actually store the data in your
database.
4.
Computations and database management - this section of memory is used for tem-
porary computations and the processing involved in database management.
5.
Free memory - this is memory that is not in use and is available for use as storage
and additional computational space.
Many people have asked how they can determine how much memory is in use for compu-
tations and database management, since this is not something that is measured in any of the
memory management views or landscape monitoring views in HANA Studio. The solution
for this is to build a calculation view on system statistic tables. You will need to create a
customer calculation view like the one shown in Figure 7.1.
