Table of Contents

About

An SAP HANA system consists of multiple services

Savepoint

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

List

Management

Data Dictionary

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

Monitoring

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

Sap Hana Studio Administration Landscape

  • Sql can also be used.

See also Service

Stop a service

ALTER SYSTEM STOP SERVICE (host,port)

Kill a service

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

Reconfigure a service

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

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

Documentation / Reference