- 重要な情報
- はじめに
- 用語集
- ガイド
- エージェント
- インテグレーション
- OpenTelemetry
- 開発者
- API
- CoScreen
- アプリ内
- Service Management
- インフラストラクチャー
- アプリケーションパフォーマンス
- 継続的インテグレーション
- ログ管理
- セキュリティ
- UX モニタリング
- 管理
Supported OS
このチェックは、Datadog Agent を通じて SAP HANA 2.0, SPS 2 を監視します。
SAP HANA チェックは、Datadog Agent のパッケージに含まれています。このインテグレーションを使用するには、hdbcli ライブラリを手動でインストールする必要があります。
Unix: の場合:
sudo -Hu dd-agent /opt/datadog-agent/embedded/bin/pip install hdbcli==2.10.15
Windows の場合:
"C:\Program Files\Datadog\Datadog Agent\embedded<PYTHON_MAJOR_VERSION>\python.exe" -m pip install hdbcli==2.10.15
特定のビューを照会するには、選択した HANA 監視ユーザーに特定の特権を付与する必要があります。詳細については、権限の付与を参照してください。
HANA テナント、シングルテナント、システムデータベースのポート番号を設定する方法については、SAP への接続のドキュメントを参照してください。
システムデータベースに接続し、次のコマンドを実行してユーザーを作成します。
CREATE RESTRICTED USER <USER> PASSWORD <PASSWORD>;
次のコマンドを実行して、ユーザーがシステムに接続できるようにします。
ALTER USER <USER> ENABLE CLIENT CONNECT;
(任意)サービスの中断を回避するために、パスワードの有効期間を長くすることができます。
ALTER USER <USER> DISABLE PASSWORD LIFETIME;
次のコマンドを実行して監視ロールを作成します(これらの例では DD_MONITOR
と呼びます)。
CREATE ROLE DD_MONITOR;
次のコマンドを実行して、すべてのシステムビューへの読み取り専用アクセスを許可します。
GRANT CATALOG READ TO DD_MONITOR;
次に、次のコマンドを実行して、各システムビューで選択権限を付与します。
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;
最後に、次のコマンドを実行して、目的のユーザーに監視ロールを割り当てます。
GRANT DD_MONITOR TO <USER>;
sap_hana のパフォーマンスデータの収集を開始するには、Agent のコンフィギュレーションディレクトリのルートにある conf.d/
フォルダーの sap_hana.d/conf.yaml
ファイルを編集します。使用可能なすべてのコンフィギュレーションオプションの詳細については、サンプル sap_hana.d/conf.yaml を参照してください。
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.connection.queuing (gauge) | The current number of queued connections. Shown as connection |
sap_hana.connection.empty (gauge) | Historic connections that are removed after a period of time. 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 には、イベントは含まれません。
sap_hana.can_connect
Returns CRITICAL
if the Agent is unable to connect to the monitored SAP HANA system, or OK
otherwise.
Statuses: ok, critical
sap_hana.status
Returns OK
if the monitored SAP HANA database is up, or CRITICAL
otherwise.
Statuses: ok, critical
ご不明な点は、Datadog のサポートチームまでお問合せください。