SAP Hana - Services (Process)
About
An SAP HANA system consists of multiple services
Articles Related
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
- the indexserver service,
- the main database service.
- the daemon service
- a database in case of mutli-tenant.
Management
Data Dictionary
- M_SERVICES: Status of all services
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.
- 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