SAP Hana Cloud

Supported OS Linux Windows Mac OS

Integration version1.0.0

SAP Hana Cloud Overview

Overview

Datadog’s SAP HANA Cloud integration connects to SAP’s Metrics Service (resource telemetry) and Metering API (billing deltas) to give you real-time visibility into database performance and cost. Out-of-the-box dashboards and monitors help you spot hotspots, diagnose blocked work, and see what’s driving your bill. With this integration, you can:

Monitor system health at a glance: Track memory and CPU usage, disk consumption, active and idle connections, sessions, and network and I/O throughput across instances and services.
Detect contention and regressions: Analyze blocked transactions, MVCC versions, SQL throughput, and column-store unloads and merges to pinpoint performance pressure and query churn.
Optimize capacity proactively: Use insights like idle-connection ratios and per-service usage trends to right-size resources before issues arise.
Understand cost drivers: Ingest hourly capacity unit (CU) deltas for memory, storage, vCPU, network egress, and backups-broken down by node type and tags-to attribute spend accurately.

Collected metrics

Resource metrics
Gain visibility into core resource indicators-memory and CPU utilization, connection and session counts, blocked transactions, MVCC versions, SQL throughput, column-store operations, disk usage, data and log I/O, and network traffic-to assess the health and performance of your HANA Cloud environment.
Metering metrics
Track capacity unit (CU) consumption for memory, storage, vCPU, network egress, backups, and more to better understand and allocate the cost of your HANA Cloud instance.

Setup

Installation

In the SAP BTP Cockpit, go to the subaccount where your SAP HANA Cloud database is running.
In the Instances list, open the Service Binding associated with the instance.
Locate the uaa section and copy the following fields:
- Client ID: uaa.clientid
- Client Secret: uaa.clientsecret
- UAA URL: uaa.url
The host address follows the format https://api.gateway.orchestration.<cluster>-<datacenter>.hanacloud.ondemand.com. For more information, see the SAP HANA Cloud metrics API documentation. Identify the datacenter and the Cluster in your subaccount overview:
- Datacenter: The region associated with your SAP BTP subaccount (for example, us10 or eu10).
- Cluster: Typically identifies either a production or preproduction environment.

For example, in https://api.gateway.orchestration.prod- us10.hanacloud.ondemand.com, the cluster is prod and cluster=prod and the datacenter is us10.

Paste all fields into the Datadog configuration form and click Save.

Validation

After you install the integration, search your metrics for sap_hana_cloud to confirm data is flowing into your account.

Data Collected

Metrics


sap_hana_cloud.resource_usage.hdbdiskstotalsize (gauge)	Usable total disk size by device
sap_hana_cloud.resource_usage.hdbhostmemoryallocationlimit (gauge)	Memory allocation limit for all processes of an SAP HANA instance
sap_hana_cloud.resource_usage.hdblogbackupwritesize (count)	Data written to log backup since service start
sap_hana_cloud.resource_usage.hdbinternaltransactioncount (gauge)	Number of internal transactions
sap_hana_cloud.resource_usage.hdbinternalconnectioncount (gauge)	Number of open SQL internal connections
sap_hana_cloud.resource_usage.hdbidleconnectioncount (gauge)	Number of open SQL idle connections
sap_hana_cloud.resource_usage.hdbhostnetworkout (count)	Bytes written to network by all processes
sap_hana_cloud.resource_usage.hdbhostnetworkin (count)	Bytes read from network by all processes
sap_hana_cloud.resource_usage.hdbhostmemoryused (gauge)	Memory used for all SAP HANA processes
sap_hana_cloud.resource_usage.hdbhostmemorysize (gauge)	Physical memory size
sap_hana_cloud.resource_usage.hdbhostdiskused (gauge)	Disk used aggregated to host level
sap_hana_cloud.resource_usage.hdbdisksusedsize (gauge)	Used disk size by device
sap_hana_cloud.resource_usage.hdbhostdisksize (gauge)	Disk size aggregated to host level
sap_hana_cloud.resource_usage.hdbhostvcpucount (gauge)	Compute resources available in VCPUs
sap_hana_cloud.resource_usage.hdbhostcpu (gauge)	CPU used by all processes (100% means all provisioned vCPUs are in use)
sap_hana_cloud.resource_usage.hdbhandlecount (gauge)	Number of open handles
sap_hana_cloud.resource_usage.hdbexternaltransactioncount (gauge)	Number of external transactions
sap_hana_cloud.resource_usage.hdbexternalconnectioncount (gauge)	Number of open SQL external connections
sap_hana_cloud.resource_usage.hdbestimatedmemorysize (gauge)	Instance memory estimation for optimal performance
sap_hana_cloud.resource_usage.hdbestimatedmemoryminsize (gauge)	Memory lower limit up to which instance can be downsized safely
sap_hana_cloud.resource_usage.hdblogbackupwritetime (count)	Total write time to log backup since service start
sap_hana_cloud.resource_usage.hdblogreadsize (count)	Data read from log since service start
sap_hana_cloud.resource_usage.hdblogreadtime (count)	Total read time from log since service start
sap_hana_cloud.resource_usage.hdblogwritesize (count)	Data written to log since service start
sap_hana_cloud.resource_usage.hdbwaitingsqlexecutorcount (gauge)	Number of waiting SqlExecutors
sap_hana_cloud.resource_usage.hdbusertransactioncount (gauge)	Number of user transactions
sap_hana_cloud.resource_usage.hdbtransactioncount (gauge)	Number of open SQL transactions
sap_hana_cloud.resource_usage.hdbtotalthreadcount (gauge)	Total number of threads
sap_hana_cloud.resource_usage.hdbtotalsqlexecutorcount (gauge)	Total number of SqlExecutors
sap_hana_cloud.resource_usage.hdbsystemcpu (gauge)	OS kernel or system CPU used by the service (100% = all vCPUs)
sap_hana_cloud.resource_usage.hdbstatementcount (count)	Number of statement executions since service start
sap_hana_cloud.resource_usage.hdbserviceactive (gauge)	Availability check for service (1/0)
sap_hana_cloud.resource_usage.hdbrecordlockcount (gauge)	Number of acquired record locks
sap_hana_cloud.resource_usage.hdbreadwritelockcollisioncount (count)	Number of collisions on read-write-lock exclusive accesses since service start
sap_hana_cloud.resource_usage.hdbpingtime (gauge)	Duration of service ping request
sap_hana_cloud.resource_usage.hdbpendingsessioncount (gauge)	Number of pending requests
sap_hana_cloud.resource_usage.hdbmvccversioncount (gauge)	Number of active MVCC versions
sap_hana_cloud.resource_usage.hdbmutexcollisioncount (count)	Number of collisions on mutexes since service start
sap_hana_cloud.resource_usage.hdbmemoryused (gauge)	Memory used by the service
sap_hana_cloud.resource_usage.hdbmemoryallocationlimit (gauge)	Memory allocation limit for Service
sap_hana_cloud.resource_usage.hdblogwritetime (count)	Total write time to log since service start
sap_hana_cloud.resource_usage.hdbdiskusageusedsize (gauge)	Detailed disk usage size by usage type
sap_hana_cloud.resource_usage.hdbwaitingthreadcount (gauge)	Number of waiting threads
sap_hana_cloud.resource_usage.hdbactivethreadcount (gauge)	Number of active threads
sap_hana_cloud.resource_usage.hdbconnectioncount (gauge)	Number of open SQL connections
sap_hana_cloud.resource_usage.hdbaccessible (gauge)	Ping check succeeded (1) or failed (0) for HDB
sap_hana_cloud.resource_usage.hdbactivesqlexecutorcount (gauge)	Number of active SqlExecutors
sap_hana_cloud.resource_usage.hdbdatawritetime (count)	Total overall write time per service and data type (data) since service start
sap_hana_cloud.resource_usage.hdbadmissioncontroladmitcount (count)	Accumulated connection request admission count since service start
sap_hana_cloud.resource_usage.hdbadmissioncontrolqueuesize (gauge)	Number of session requests waiting in admission control queue
sap_hana_cloud.resource_usage.hdbadmissioncontrolrejectcount (count)	Accumulated connection request rejection count since service start
sap_hana_cloud.resource_usage.hdbadmissioncontrolwaittime (count)	Total wait time of connection requests in queue since service start
sap_hana_cloud.resource_usage.hdbblockedtransactioncount (gauge)	Number of blocked SQL transactions
sap_hana_cloud.resource_usage.hdbbuffercachestatisticsusedsize (gauge)	Buffer cache memory being used for data
sap_hana_cloud.resource_usage.hdbcommitidrange (gauge)	Range between newest and oldest active Commit ID
sap_hana_cloud.resource_usage.hdbbackuptotalsize (gauge)	Total size of backup catalog files
sap_hana_cloud.resource_usage.hdbcpu (gauge)	CPU used by the service (100% means all provisioned vCPUs are in use)
sap_hana_cloud.resource_usage.hdbdatabackupwritesize (count)	Size of all written data per service and data type (data backup) since service start
sap_hana_cloud.resource_usage.hdbdatawritesize (count)	Size of all written data per service and data type (data) since service start
sap_hana_cloud.resource_usage.hdbcsmergecount (count)	Number of column store merge requests
sap_hana_cloud.resource_usage.hdbdatareadsize (count)	Size of all read data per service and data type (data) since service start
sap_hana_cloud.resource_usage.hdbdatabackupwritetime (count)	Total overall write time per service and data type (data backup) since service start
sap_hana_cloud.resource_usage.hdbdatareadtime (count)	Total overall read time per service and data type (data) since service start
sap_hana_cloud.resource_usage.hdbcswritecount (count)	Number of column store write requests
sap_hana_cloud.resource_usage.hdbcsunloadcount (count)	Number of column store unload requests (low memory or unused resource)
sap_hana_cloud.resource_usage.hdbcsreadcount (count)	Number of column store read requests
sap_hana_cloud.metering.cloudconnectorvcpu (gauge)	Cloud connector vCPU allocated
sap_hana_cloud.metering.defaultnodevcpu (gauge)	Default node vCPU allocated
sap_hana_cloud.metering.networkegress (gauge)	Network egress bytes
sap_hana_cloud.metering.snapshotstorage (gauge)	Snapshot storage consumed
sap_hana_cloud.metering.asynchronousreplicanodememory (gauge)	Async replica memory allocated
sap_hana_cloud.metering.asynchronousreplicanodestorage (gauge)	Async replica storage consumed
sap_hana_cloud.metering.asynchronousreplicanodevcpu (gauge)	Async replica vCPU allocated
sap_hana_cloud.metering.cloudconnectormemory (gauge)	Cloud connector memory allocated
sap_hana_cloud.metering.cloudconnectornetworkegress (gauge)	Cloud connector network egress
sap_hana_cloud.metering.defaultnodestorage (gauge)	Default node storage consumed
sap_hana_cloud.metering.computenodememory (gauge)	Compute node memory allocated
sap_hana_cloud.metering.computenodenetworkegress (gauge)	Compute node network egress
sap_hana_cloud.metering.computenodestorage (gauge)	Compute node storage consumed
sap_hana_cloud.metering.computenodevcpu (gauge)	Compute node vCPU allocated
sap_hana_cloud.metering.synchronousreplicanodememory (gauge)	Sync replica memory allocated
sap_hana_cloud.metering.synchronousreplicanodestorage (gauge)	Sync replica storage consumed
sap_hana_cloud.metering.synchronousreplicanodevcpu (gauge)	Sync replica vCPU allocated
sap_hana_cloud.metering.defaultnodememory (gauge)	Default node memory allocated
sap_hana_cloud.metering.backupstorage (gauge)	Backup storage consumed

Uninstallation

Remove any accounts created during installation.

Note: Deleting an account does not remove data that this integration has already collected, but it stops further collection of metrics for the account.