SAP HANA
セキュリティモニタリングが使用可能です セキュリティモニタリングが使用可能です

SAP HANA

Agent Check Agentチェック

Supported OS: Linux Mac OS Windows

概要

このチェックは、Datadog Agent を通じて SAP HANA 2.0, SPS 2 を監視します。

セットアップ

インストール

SAP HANA チェックは Datadog Agent パッケージに含まれています。

HANA の準備

特定のビューを照会するには、選択した HANA 監視ユーザーに特定の特権を付与する必要があります。詳細については、権限の付与を参照してください。

ユーザーの作成
  1. システムデータベースに接続し、次のコマンドを実行してユーザーを作成します。

    CREATE RESTRICTED USER <USER> PASSWORD <PASSWORD>
  2. 次のコマンドを実行して、ユーザーがシステムに接続できるようにします。

    ALTER USER <USER> ENABLE CLIENT CONNECT
  3. (任意)サービスの中断を回避するために、パスワードの有効期間を長くすることができます。

    ALTER USER <USER> DISABLE PASSWORD LIFETIME
権限の付与
  1. 次のコマンドを実行して監視ロールを作成します(これらの例では DD_MONITOR と呼びます)。

    CREATE ROLE DD_MONITOR
  2. 次のコマンドを実行して、すべてのシステムビューへの読み取り専用アクセスを許可します。

    GRANT CATALOG READ TO DD_MONITOR
  3. 次に、次のコマンドを実行して、各システムビューで選択権限を付与します。

    GRANT SELECT ON SYS.M_DATABASE TO DD_MONITOR
    GRANT SELECT ON SYS.M_DATABASES TO DD_MONITOR
    GRANT SELECT ON SYS_DATABASES.M_BACKUP_PROGRESS TO DD_MONITOR
    GRANT SELECT ON SYS_DATABASES.M_CONNECTIONS TO DD_MONITOR
    GRANT SELECT ON SYS_DATABASES.M_DISK_USAGE TO DD_MONITOR
    GRANT SELECT ON SYS_DATABASES.M_LICENSES TO DD_MONITOR
    GRANT SELECT ON SYS_DATABASES.M_RS_MEMORY TO DD_MONITOR
    GRANT SELECT ON SYS_DATABASES.M_SERVICE_COMPONENT_MEMORY TO DD_MONITOR
    GRANT SELECT ON SYS_DATABASES.M_SERVICE_MEMORY TO DD_MONITOR
    GRANT SELECT ON SYS_DATABASES.M_SERVICE_STATISTICS TO DD_MONITOR
    GRANT SELECT ON SYS_DATABASES.M_VOLUME_IO_TOTAL_STATISTICS TO DD_MONITOR
  4. 最後に、次のコマンドを実行して、目的のユーザーに監視ロールを割り当てます。

    GRANT DD_MONITOR TO <USER>

コンフィギュレーション

  1. sap_hana のパフォーマンスデータの収集を開始するには、Agent の構成ディレクトリのルートにある conf.d/ フォルダーの sap_hana.d/conf.yaml ファイルを編集します。使用可能なすべての構成オプションの詳細については、サンプル sap_hana.d/conf.yaml を参照してください。

  2. Agent を再起動します

検証

Agent の status サブコマンドを実行し、Checks セクションの sap_hana を探します。

収集データ

メトリクス

sap_hana.backup.latest
(gauge)
The time elapsed since the latest database backup was completed.
Shown as second
sap_hana.connection.idle
(gauge)
The current number of idle connections.
Shown as connection
sap_hana.connection.open
(gauge)
The current number of connections.
Shown as connection
sap_hana.connection.running
(gauge)
The current number of running connections.
Shown as connection
sap_hana.cpu.service.utilized
(gauge)
The CPU utilization of services as a percentage.
Shown as percent
sap_hana.disk.free
(gauge)
The total free size of the disk in bytes.
Shown as byte
sap_hana.disk.size
(gauge)
The total size of the disk in bytes.
Shown as byte
sap_hana.disk.used
(gauge)
The total used size of the disk in bytes.
Shown as byte
sap_hana.disk.utilized
(gauge)
The utilization of the disk as a percentage.
Shown as percent
sap_hana.file.service.open
(gauge)
The number of open files.
Shown as file
sap_hana.license.expiration
(gauge)
The time until license expiration.
Shown as second
sap_hana.license.size
(gauge)
The total size of the license in gibibytes.
Shown as gibibyte
sap_hana.license.usable
(gauge)
The total usable size of the license in gibibytes.
Shown as gibibyte
sap_hana.license.used
(gauge)
The total used size of the license in gibibytes.
Shown as gibibyte
sap_hana.license.utilized
(gauge)
The utilization of the license as a percentage.
Shown as percent
sap_hana.memory.row_store.free
(gauge)
The total free amount of row store memory in bytes.
Shown as byte
sap_hana.memory.row_store.total
(gauge)
The total amount of row store memory in bytes.
Shown as byte
sap_hana.memory.row_store.used
(gauge)
The total used amount of row store memory in bytes.
Shown as byte
sap_hana.memory.row_store.utilized
(gauge)
The utilization of row store memory as a percentage.
Shown as percent
sap_hana.memory.service.component.used
(gauge)
The total used amount of memory by service components in bytes.
Shown as byte
sap_hana.memory.service.compactor.free
(gauge)
The total free part of the service memory pool that can potentially be freed on memory shortage in bytes.
Shown as byte
sap_hana.memory.service.compactor.total
(gauge)
The total part of the service memory pool that can potentially be freed on memory shortage in bytes.
Shown as byte
sap_hana.memory.service.compactor.used
(gauge)
The total used part of the service memory pool that can potentially be freed on memory shortage in bytes.
Shown as byte
sap_hana.memory.service.compactor.utilized
(gauge)
The utilization of the part of the service memory pool that can potentially be freed on memory shortage as a percentage.
Shown as percent
sap_hana.memory.service.heap.free
(gauge)
The total free amount of service heap memory in bytes.
Shown as byte
sap_hana.memory.service.heap.total
(gauge)
The total amount of service heap memory in bytes.
Shown as byte
sap_hana.memory.service.heap.used
(gauge)
The total used amount of service heap memory in bytes.
Shown as byte
sap_hana.memory.service.heap.utilized
(gauge)
The utilization of service heap memory as a percentage.
Shown as percent
sap_hana.memory.service.overall.physical.total
(gauge)
The total amount of service physical RAM in bytes.
Shown as byte
sap_hana.memory.service.overall.free
(gauge)
The total free amount of service memory in bytes.
Shown as byte
sap_hana.memory.service.overall.total
(gauge)
The total amount of service memory in bytes.
Shown as byte
sap_hana.memory.service.overall.used
(gauge)
The total used amount of service memory in bytes.
Shown as byte
sap_hana.memory.service.overall.utilized
(gauge)
The utilization of service memory as a percentage.
Shown as percent
sap_hana.memory.service.overall.virtual.total
(gauge)
The total amount of service virtual RAM in bytes.
Shown as byte
sap_hana.memory.service.shared.free
(gauge)
The total free amount of service shared memory in bytes.
Shown as byte
sap_hana.memory.service.shared.total
(gauge)
The total amount of service shared memory in bytes.
Shown as byte
sap_hana.memory.service.shared.used
(gauge)
The total used amount of service shared memory in bytes.
Shown as byte
sap_hana.memory.service.shared.utilized
(gauge)
The utilization of service shared memory as a percentage.
Shown as percent
sap_hana.network.service.request.active
(gauge)
The number of active requests to services.
Shown as request
sap_hana.network.service.request.external.total_finished
(count)
The number of completed external requests to services.
Shown as request
sap_hana.network.service.request.internal.total_finished
(count)
The number of completed internal requests to services.
Shown as request
sap_hana.network.service.request.pending
(gauge)
The number of pending requests to services.
Shown as request
sap_hana.network.service.request.per_second
(gauge)
The average number of requests per second of services over the last 1000 requests.
Shown as request
sap_hana.network.service.request.response_time
(gauge)
The average request response time of services over the last 1000 requests.
Shown as millisecond
sap_hana.network.service.request.total_finished
(count)
The total number of completed requests to services.
Shown as request
sap_hana.thread.service.active
(gauge)
The number of active threads used by services.
Shown as thread
sap_hana.thread.service.inactive
(gauge)
The number of inactive threads used by services.
Shown as thread
sap_hana.thread.service.total
(gauge)
The number of total threads used by services.
Shown as thread
sap_hana.uptime
(gauge)
The time elapsed since the database was started.
Shown as second
sap_hana.volume.io.read.count
(count)
The number of reads from the volume within the last interval.
Shown as read
sap_hana.volume.io.read.size.count
(count)
The number of bytes read from the volume within the last interval.
Shown as byte
sap_hana.volume.io.read.size.total
(gauge)
The total number of bytes read from the volume.
Shown as byte
sap_hana.volume.io.read.total
(gauge)
The total number of reads from the volume.
Shown as read
sap_hana.volume.io.read.utilized
(gauge)
The percentage of time spent reading from the volume.
Shown as percent
sap_hana.volume.io.throughput
(gauge)
The overall throughput of a volume in bytes per second.
Shown as byte
sap_hana.volume.io.utilized
(gauge)
The percentage of time spent accessing the volume.
Shown as percent
sap_hana.volume.io.write.count
(count)
The number of writes to the volume within the last interval.
Shown as write
sap_hana.volume.io.write.size.count
(count)
The number of bytes written to the volume within the last interval.
Shown as byte
sap_hana.volume.io.write.size.total
(gauge)
The total number of bytes written to the volume.
Shown as byte
sap_hana.volume.io.write.total
(gauge)
The total number of writes to the volume.
Shown as write
sap_hana.volume.io.write.utilized
(gauge)
The percentage of time spent writing to the volume.
Shown as percent

サービスのチェック

sap_hana.can_connect:
Agent が監視対象の SAP HANA システムに接続できない場合は、CRITICAL を返します。それ以外の場合は、OK を返します。

sap_hana.status:
監視対象の SAP HANA データベースが起動している場合は、OK を返します。それ以外の場合は、CRITICAL を返します。

イベント

SAP HANA には、イベントは含まれません。

トラブルシューティング

ご不明な点は、Datadog のサポートチームまでお問合せください。