Huawei Cloud Data Warehouse Service DWS
Collect Huawei Cloud DWS monitoring metrics
Configuration¶
Install Func¶
It is recommended to activate the TrueWatch Integration - Extensions - DataFlux Func (Automata): all prerequisites are automatically installed, please proceed with the script installation.
For self-deployment of Func, refer to Self-deploying Func
Install Script¶
Note: Please prepare the Huawei Cloud AK with the required permissions in advance (for simplicity, you can grant the global read-only permission
ReadOnlyAccess
)
-
Log in to the Func console, click on 【Script Market】, and enter the TrueWatch Script Market to search for
integration_huaweicloud_dws
. -
Click 【Install】, then input the corresponding parameters: Huawei Cloud AK, SK, and account name.
-
Click 【Deploy Startup Script】, the system will automatically create the
Startup
script set and configure the corresponding startup scripts. -
After enabling, you can see the corresponding automatic trigger configuration in 「Manage / Automatic Trigger Configuration」. Click 【Execute】 to immediately execute once without waiting for the scheduled time. After a while, you can check the execution task records and corresponding logs.
Verification¶
- In 「Manage / Automatic Trigger Configuration」, confirm whether the corresponding task has the automatic trigger configuration, and check the task records and logs for any exceptions.
- In TrueWatch, check if there is asset information in 「Infrastructure - Resource Catalog」.
- In TrueWatch, check if there is corresponding monitoring data in 「Metrics」.
Metrics¶
Collect Huawei Cloud Data Warehouse Service DWS metrics, more metrics can be collected through configuration Huawei Cloud DWS Metrics Details
Huawei Cloud DWS metrics are under the huaweicloud_SYS.DWS
measurement, below are the DWS related metric descriptions
Metric ID | Metric Name | Metric Meaning | Value Range | Unit | Measurement Object (Dimension) | Monitoring Period (Original Metric) |
---|---|---|---|---|---|---|
dws001_shared_buffer_hit_ratio |
Cache Hit Ratio | This metric indicates the ratio of data requests that are already in the cache to the total data requests in the system. The higher the cache hit ratio, the higher the cache utilization of the system, and the fewer times data needs to be read from the disk or network, the faster the system response speed. | 0%~100% | % | Data Warehouse Cluster | 4 minutes |
dws002_in_memory_sort_ratio |
Cache Hit Ratio | This metric represents the ratio of additional memory space used by the sorting algorithm to the memory space occupied by the sorted data. | 0%~100% | % | Data Warehouse Cluster | 4 minutes |
dws003_physical_reads |
File Reads | This metric represents the cumulative number of times database files are read. | > 0 | count | Data Warehouse Cluster | 4 minutes |
dws004_physical_writes |
File Writes | This metric represents the cumulative number of times database files are written. | > 0 | count | Data Warehouse Cluster | 4 minutes |
dws005_physical_reads_per_second |
File Reads Per Second | This metric represents the number of times database files are read per second. | ≥ 0 | count/s | Data Warehouse Cluster | 4 minutes |
dws006_physical_writes_per_second |
File Writes Per Second | This metric represents the number of times database files are written per second. | ≥ 0 | count/s | Data Warehouse Cluster | 4 minutes |
dws007_db_size |
Database Size | This metric represents the total size of all data in the database. | ≥0MB | MB | Data Warehouse Cluster | 4 minutes |
dws008_active_sql_count |
Active SQL Count | This metric represents the number of currently active SQLs in the database. | ≥ 0 | count | Data Warehouse Cluster | 4 minutes |
dws009_session_count |
Session Count | This metric represents the number of current connections accessing the database. | ≥ 0 | count | Data Warehouse Cluster | 4 minutes |
dws009_session_count |
Session Count | This metric represents the number of current connections accessing the database. | ≥ 0 | count | Data Warehouse Cluster | 4 minutes |
dws010_cpu_usage |
CPU Usage | This metric represents the CPU usage rate of each cluster node. | 0%~100% | % | Data Warehouse Node | 1 minute |
dws011_mem_usage |
Memory Usage | This metric represents the memory usage rate of each cluster node. | 0%~100% | % | Data Warehouse Node | 1 minute |
dws012_iops |
IOPS | This metric represents the number of I/O requests processed per second by each cluster node. | ≥ 0 | count/s | Data Warehouse Node | 1 minute |
dws013_bytes_in |
Network Input Throughput | This metric represents the total amount of data input to each cluster node from the network per second. | ≥ 0 bytes/second | byte/s | Data Warehouse Node | 1 minute |
dws014_bytes_out |
Network Output Throughput | This metric represents the total amount of data sent from each node to the network per second. | ≥ 0 bytes/second | byte/s | Data Warehouse Node | 1 minute |
dws015_disk_usage |
Disk Usage | This metric represents the disk usage of each cluster node. | 0%~100% | % | Data Warehouse Node | 1 minute |
dws016_disk_total_size |
Disk Total Size | This metric represents the total size of the data disk of each cluster node. | 100GB~2000GB | GB | Data Warehouse Node | 1 minute |
dws017_disk_used_size |
Disk Used Size | This metric represents the used size of the data disk of each cluster node. | 0GB~3600GB | GB | Data Warehouse Node | 1 minute |
dws018_disk_read_throughput |
Disk Read Throughput | This metric represents the amount of data read from the data disk of each cluster node per second. | ≥ 0 bytes/second | byte/s | Data Warehouse Node | 1 minute |
dws019_disk_write_throughput |
Disk Write Throughput | This metric represents the amount of data written to the data disk of each cluster node per second. | ≥ 0 bytes/second | byte/s | Data Warehouse Node | 1 minute |
dws020_avg_disk_sec_per_read |
Disk Read Latency | This metric represents the average latency of each data read from the data disk of each cluster node. | > 0 seconds | Second | Data Warehouse Node | 1 minute |
dws021_avg_disk_sec_per_write |
Disk Write Latency | This metric represents the average latency of each data write to the data disk of each cluster node. | > 0 seconds | Second | Data Warehouse Node | 1 minute |
dws022_avg_disk_queue_length |
Disk Average Queue Length | This metric represents the average I/O queue length of the data disk of each cluster node. | ≥ 0 | count | Data Warehouse Node | 1 minute |
Object¶
After data is synchronized normally, you can view the data in TrueWatch's 「Infrastructure - Resource Catalog」.
{
"measurement": "huaweicloud_dws",
"tags": {
"RegionId" : "cn-south-4",
"project_id" : "756ada1aa17e4049b2a16ea41912e52d",
"enterprise_project_id" : "0824ss-xxxx-xxxx-xxxx-12334fedffg",
"datastore_id" : "xxxxxx",
"datastore_name" : "test"
},
"fields": {
"status" : "AVAILABLE",
"version" : "8.0.x",
"port" : "8000",
"user_name" : "xxxxx",
"availability_zone" : "cn-south-4a",
"node_type" : "dwsk2-xxx-xxx",
"sub_status" : "xxxxxxxxx",
"create_time" : "2024-11-11T08:15:58Z",
"update_time" : "2024-11-11T08:15:58Z",
"endpoints" : "xxxxx",
"nodes" : "[]",
"number_of_node" : "3",
"recent_event" : "2",
"public_endpoints" : "[]",
"action_progress" : "{}",
"public_ip" : "xxxxxxxx"
}
}
Note: The fields in
tags
andfields
may change with subsequent updates. ```