Database Reference
In-Depth Information
By default, the memory allocation limit is set to 90% of available memory for the first 64
GB of memory available on the host and 97% of each additional gigabyte of memory. This
reserves room for Linux and core HANA processes in the available memory.
Overriding defaults
If you have purchased HANA licenses for less memory than is phys-
ically available in your HANA appliance, you can override the de-
faults for the global allocation limit in the global.ini file and set the
limit to less than the maximum memory in the appliance.
To check the status of the alerts from the DBACOCKPIT, select
A
LERTS
from the navig-
ation panel. Alerts will be listed in the top panel, along with recommended user actions to
resolve the problem that is being reported. Additional information about each alert can be
found in the bottom panel, and includes a detailed description, the time the alert occurred,
and the next time the status will be updated.
In the
P
ERFORMANCE
section, the
S
TATISTICS
S
ERVER
provides a list of the statistical
tables that can be viewed from the DBACOCKPIT. Please note that you will need to manu-
ally enable the statistics server from HANA Studio in order to monitor it from BW. More
information about enabling the statistics server in HANA Studio can be found in
Section
You should also take a look at the
E
XPENSIVE
S
TATEMENTS
section of
P
ERFORMANCE
.
This section contains information about statements that run for a long period of time. You
can set up traces to monitor the amount of memory that is used by any one statement in the
global.ini file.
You can monitor the
L
ANDSCAPE
in the
C
ONFIGURATION
section of the navigation pane.
From here, you can see which systems are connected and what their role is within the over-
all system landscape. You can also determine whether systems are active or are in standby
by checking their status in the
I
NDEXSERVER
A
CTUAL
R
OLE
column of this report, as
shown in Figure 7.6. In the example, Host km3hf130 is a standby system for high-availab-
ility failover.
