SAP HANA MDC監視ツール
Overview
ManageEngine Applications Managerは、SAP HANA MDC（マルチテナントデータベースコンテナ）データベースサーバーを包括的に監視します。
これにより、システムデータベースとテナントデータベースの両方のパフォーマンスと可用性を詳細に可視化できます。この監視を使用すると、メモリ使用量、CPU使用率、接続統計、高負荷なステートメント、ディスク使用量、データバックアップの詳細など、主要なパフォーマンスメトリクスを追跡できます。
また、しきい値ベースのアラートを設定し、洞察に富んだレポートを生成することで、プロアクティブなデータベース管理をサポートできます。Applications ManagerによるSAP HANA
MDCの監視は、最適なパフォーマンスを確保し、情報に基づいたキャパシティプランニングの意思決定に役立ちます。
新規監視追加方法
SAP HANA MDCメトリクスを監視するための前提条件： こちらをご参照ください。
REST APIを使用して新規SAP HANA MDC監視を追加： こちらをご参照ください。
SAP HANA MDCサーバー監視を作成するには、次の手順に従います。
- 新規監視追加をクリックします。
- データベースサーバー配下のSAP HANA MDCを選択します。
- SAP HANA MDC監視の表示名を指定します。
- HANA MDCサーバーのホスト名を指定します。
- SAP HANA Cloud Platformを使用する場合：
- SAP HANA Cloud Platformを選択します。
- クラウドのアカウント名、ユーザー名、パスワードを入力します。
- ポートとしてIndexServerポートを入力します。デフォルトのポートは30015です。
- ご自身の認証情報を入力するか、認証情報マネージャーから事前設定された認証情報を選択できます。
ご自身の認証情報を入力する場合は、この監視のSAP HANAユーザー名とパスワードを指定してください。 - データベースユーザー名とデータベースパスワードを入力します。
- SSLを有効にするボックスをチェックすると、SSL暗号化を使用して安全な接続が確立されます。
- hostnameInCertificateフィールドに、サーバーのIDを検証するために使用するホスト名を入力します。
- タイムアウト値を秒単位で指定します。デフォルト値は20秒です。
- ポーリング間隔を設定します。
- セントラルサーバーから新しい監視を追加する場合は、プローブサーバーを選択します。
- SAP HANA MDCサーバー監視を関連付ける監視グループをコンボボックスから選択します（オプション）。
監視を関連付けるグループは複数選択できます。 - 「監視の追加」をクリックします 。これにより、ネットワークからSAP HANA MDCサーバーが検出され、監視が開始されます。
監視パラメーター
監視タブをクリックして、監視カテゴリ ビューに移動します。データベースサーバーセクションのSAP HANA MDCをクリックします。また、SAP HANA MDCは子モニターとしてSAP HANAをサポートしています。3つのタブに分かれたSAP HANA MDCの一括設定ビューが表示されます。
- 可用性タブでは、過去24時間か30日の可用性履歴がわかります。
- パフォーマンス タブでは、過去24時間か30日のステータスとイベントがわかります。
- リスト ビューでは、一括管理設定が可能です。
監視名をクリックすると、次のタブにリストされているすべてのサーバー詳細が表示されます。:
概要
| パラメーター | 説明 |
|---|---|
| System Information | |
| Version | The version of the SAP HANA MDC database that is installed on the system. |
| System Type | A SAP HANA MDC system can be configured as a single-host or multiple-host system. |
| All Services Started | Indicates if all services are started and the system is operational and accessible. |
| Platform | The operating system of the SAP HANA MDC system. |
| Instance ID | The instance ID of the SAP HANA MDC database. |
| Connection Statistics | |
| Active Connections | Total No. of Active Connections |
| Inactive Connections | Total No.of Inactive connections |
| Tenant Databases | |
| Tenant DB Name | Name of the tenant database or instance. |
| Host Name | Host where the DB server is running. |
| Port | Tenant JDBC port for connection. |
メモリ
| パラメーター | 説明 |
|---|---|
| Memory Used by HANA | |
| Host | Host where the DB server is running. |
| Allocation Limit (GB) | Memory allocated for HANA in each host |
| Memory used by HANA (GB) | Memory Used only by HANA in each host (Total resident) |
| Allocated Memory Used (%) | Memory Used only by HANA in each host (Total resident) |
| Used by Column Tables (GB) | The amount of memory used for column tables. (A major part of the SAP HANA Used Memory is taken up by the data tables). |
| Used by Row tables (GB) | The total amount of memory used for row tables. (A major part of the SAP HANA Used Memory is taken up by the data tables). |
| Used by Code & Stack (GB) | Memory used by HANA Code and Stack |
| DataBase Resident (GB) | The amount of physical memory actually in operational use by a process. (When a part of the virtually allocated memory actually needs to be used, it is loaded or mapped to the real, physical memory of the host, and becomes "resident".) |
サービス
| パラメーター | 説明 |
|---|---|
| Service name | The name of the service. |
| CPU Usage (%) | The percentage of CPU used by the service. |
| Memory Usage (GB) | The memory used by each service. |
| Requests Per Second | The number of requests that are processed by the host computer. |
| Response Time (ms) | The time (in milliseconds) that is taken by the service to respond to requests from the clients. |
| Active Request count | The number of active requests that are being processed by the service. |
| Pending Requests count | The number of requests that are waiting in a queue to be processed by a service in the SAP HANA MDC database server. |
| Active Threads count | The total number of active threads for the service. |
| Open File Count | The number of files that are currently opened through a service in the SAP HANA MDC database server. |
| Coordinator Type | The number of files that are currently opened through a service in the SAP HANA MDC database server. |
| Service status | The status of the service. The status can be no, yes, unknown, starting and stopping. |
ディスク
| パラメーター | 説明 |
|---|---|
| Disk usage Type | The type of disk usage on the host computer. The usage types are log, data, trace, data_backup, and log_backup. |
| Total Disk Space | The total Space allocated for each Disk |
| Disk Used | Disk Used |
| Disk Free percentage | The free space percentage of the disk. |
| Disk Path | The path to the disk, disk location. |
| Disk Volume size | The total disk space in GB. |
| Disk Volume | |
| Service Name | The name of the service. |
| Volume ID | The unique volume identifier. |
| File Type | The type of file in the volume directories. Possible values are - DATA, LOG, TRACE. |
| File Name | The name of the file, |
| Total Volume Size | The total data volume sizes of the SAP HANA servers. |
| Used Volume Size | The total data volume sizes used. |
| Free Size | The free memory size of the module. |
| Volume IO Statistics | |
| Service Name | The name of the service. |
| Volume ID | The unique volume identifier. |
| Volume Path | The Filesystem path. |
| Disk Type | The Filesystem type. |
| Blocked Write Requests | The count of blocked write requests. |
| Total Reads | Total number of file reads on the disk for all file types. |
| Total Failed Reads | Total number of failed reads from the disk. |
| Total Read Size | Total size of read data (in MB). |
| Total Read Time | Total time taken to read data (in sec). |
| Total Appends | Total number of file appends on the disk for all file types. |
| Total Writes | Total number of file writes on the disk for all file types. |
| Total Failed Writes | Total number of of failed writes. |
| Total Write Size | Total size of written data (in MB). |
| Total Write Time | Total time taken to write data (in sec). |
| Total I/O Time | Total time taken to perform I/O operations (in sec). |
| Speed | The I/O performance measured in MB/sec. |
スキーマ
| パラメーター | 説明 |
|---|---|
| No.of Column Tables | The number of Column Tables in this partition. |
| Size of Column Tables | Allocated memory size for fixed-size and variable-size column table paritions. |
| No. of Row Tables | The number of Row Tables in this partition. |
| Size of row tables | Allocated memory size for fixed-size and variable-size row table partitions. |
システムレプリケーション
| パラメーター | 説明 |
|---|---|
| Site Name | Logical site name |
| Secondary Host | The secondary host name. |
| Secondary Site Name | The secondary logical site name. |
| Replication Status | Replication Status |
| Replication Mode | Replication status |
| Operation Mode | Operation mode |
バックアップ
| パラメーター | 説明 |
|---|---|
| Backup Size | The size of the backup. |
| Source Type name | Type of persistence to be backed up: 'volume', 'topology'. |
| Service Type Name | Type of database service: 'indexserver', 'nameserver', 'statisticsserver'. |
| Entry type Name | Classification of backup catalog entries: 'complete data backup', 'data snapshot', 'log backup', 'log missing' |
| Start time | Time stamp when backup started |
| Total Time | TimeTaken for Backup |
| State | Result of corresponding action: 'successful', 'failed', 'running', 'cancel pending', 'canceled' |
| Backup Configuration | |
| Max Recovery File Age | The maximum recovery file age in seconds. |
| Log Replay Step Size | The Log replay step size in bytes. |
| Max Recovery Backint Channels | The max number of parallel backint channels per request during recovery. |
| Backint Executable Link | The link name of the backint executable. |
| Backint Executable | The filename of the backint executable. |
| Backint Data Backup Path | The data backup directory for backint. |
| File Data Backup Path | The default directory for file-based data backups. |
| File Log Backup Path | The current directory for file-based log backups. |
| Latest Backup Details | |
| Latest Backup ID | The unique ID of a data backup or a log backup respectively. |
| Latest Backup Start Time | The start time of the backup operation. |
| Latest Backup End Time | The end time of the backup operation. |
| Latest Backup Entry Type | The classification of backup catalog entries. The following types are supported: 'complete data backup', 'log backup', 'log missing'. |
| Latest Backup Destination Type | The type of backup location. Possible values are - 'file' or 'backint'. |
| Latest Backup Size | Specifies the size of the backup. |
ワークロード
| パラメーター | 説明 |
|---|---|
| Current Execution Rate/min | The current statement execution count per minute. |
| Current Compilation Rate/min | The current statement preparation count per minute. |
| Current Transaction Rate/min | The current transaction count per minute. |
| Current Commit Rate/min | The total number of commits per minute. |
| Current Rollback Rate/min | The total number of rollbacks per minute. |
| Current Memory Usage Rate/min | The total size of used memory per minute. |
トランザクション
ブロックされたトランザクションデータセットは、別のトランザクション、ネットワーク、またはディスクによって保持されているトランザクションロックの取得を待機しているトランザクションに関する情報を提供します。
| パラメーター | 説明 |
|---|---|
| Blocked Transaction Id | The connection ID of the blocked transaction. |
| Lock Owner Transaction Id | The connection ID associated with the write transaction that is holding the lock. |
| Blocked Time | The time from when the transaction is blocked. |
| Waiting Schema Name | The name of the schema on which the lock is placed. |
| Waiting Object Name | The type of the object on which the lock is placed. |
| Lock Type | The type of lock that is held by the blocking transaction. The lock type can be record, object, and metadata. |
| Lock Mode | The access level of transactions to the locked record, table, and database. The lock mode can be shared, exclusive, and intentional exclusive. |
| Blocked Statement | The statement that is blocking the transaction. |
高価なステートメント
高価なステートメントデータセットは、実行時間が構成されたしきい値を超えたステートメントに関する情報を提供します。
| パラメーター | 説明 |
|---|---|
| Start Time | The time at which the execution of the statement started. |
| Statement ID | A unique identifier associated with the statement execution. |
| Statement Duration | The time that is required for executing the statement. |
| Records | The number of records in the database table. |
| Memory Size | The memory required for computing the statement. |
| DB User | The user name that is used to connect to the database. |
| Operation | Type of operation: e.g. prepare, execute, fetch, close. |
| Statement | The SQL statement that runs for duration longer than the defined threshold. |
| Error Code | The error code associated with the query. |
| Error Message | The error message associated with the error code. |
ジョブ
| パラメーター | 説明 |
|---|---|
| Connection Id | The connection that triggered the operation. |
| Schema name | Schema of the object. |
| Object name | Name of the object. |
| Job Name | The type of the operation. |
| Start Time | The time when the operation was started. |
| Current Job Progress | The current status of the operation. One of the following values is possible: inactive, active, precommitted, aborting, partial_aborting, and active_prepare_commit. |
キャッシュ
| パラメーター | 説明 |
|---|---|
| Cache id | The unique identifier for the cache. |
| Total Size | Maximum available memory for each cache instance |
| Used Size | Memory Used by Cache instance |
| Hits Count | Number of cache hits for the cache instance. |
| Misses Count | Number of cache misses for the cache instance. |
アラート
| パラメーター | 説明 |
|---|---|
| Alert ID | The ID of the current alert. |
| Alert rating | The severity of the alert occurrence. The severity might be different for each alert. The following values are possible: 1 (information message), 2 (warning level 1), 3 (warning level 2), 4 (warning level 3), 5 (error message). |
| Alert TimeStamp | The time according to the local server time when the alert was occurred. |
| Description | The information about the alert. |