An SAP HANA system consists of multiple services
In order to persist data to disk, each SAP HANA service (that persist data ie nameserver, indexserver, xsengine) has its own separate savepoints.
- M_SERVICES: Status of all services
SELECT * FROM "SYS_DATABASES"."M_SERVICE_MEMORY" -- Not the same as SELECT * FROM "PUBLIC"."M_SERVICE_MEMORY"
- Hana Studio: Administration > Landscape. Columns may be added with the “Configure Viewer” icon.
- 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