SAP Hana - Services (Process)

1 - About

An SAP HANA system consists of multiple services

3 - Savepoint

In order to persist data to disk, each SAP HANA service (that persist data ie nameserver, indexserver, xsengine) has its own separate savepoints.

4 - List

5 - Management

5.1 - Data Dictionary

SELECT * FROM "SYS_DATABASES"."M_SERVICE_MEMORY"
-- Not the same as
SELECT * FROM "PUBLIC"."M_SERVICE_MEMORY"

5.2 - Monitoring

  • Hana Studio: Administration > Landscape. Columns may be added with the “Configure Viewer” icon.

  • Sql can also be used.

See also hana:memory:service:start

5.3 - Stop a service

ALTER SYSTEM STOP SERVICE (host,port)

5.4 - Kill a service

ALTER SYSTEM KILL SERVICE (host,port) [WITH COREFILE]

5.5 - Reconfigure a service

ALTER SYSTEM RECONFIGURE SERVICE ('service', 'host', port)

Depending on service, host, port, different services can be reconfigured. See M_SERVICES

6 - Documentation / Reference


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap