Huawei Cloud Data Warehouse Service DWS
Collect Huawei Cloud DWS monitoring metrics
Configuration¶
Install Func¶
It is recommended to activate Guance Integration - Extensions - DataFlux Func (Automata): All prerequisites are automatically installed. Please proceed with the script installation.
If you are deploying Func yourself, refer to Self-deploying Func
Install Script¶
Note: Please prepare the Huawei Cloud AK with the required permissions in advance (for simplicity, you can directly grant the global read-only permission
ReadOnlyAccess
)
-
Log in to the Func console, click 【Script Market】, enter the official script market, and search for
guance_huaweicloud_dws
-
Click 【Install】, then enter 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 it 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 corresponding task records and logs for any exceptions
- In Guance, check if there is asset information in 「Infrastructure - Resource Catalog」
- In Guance, check if there are corresponding monitoring data in 「Metrics」
Metrics¶
Collect Huawei Cloud Data Warehouse Service DWS metrics, and you can collect more metrics through configuration Huawei Cloud DWS Metrics Details
Huawei Cloud DWS metrics are under the huaweicloud_SYS.DWS
Measurement. Below are the descriptions of DWS related metrics
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 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 the 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 Read Count | This metric indicates the cumulative number of times database files are read. | > 0 | count | Data Warehouse Cluster | 4 minutes |
dws004_physical_writes |
File Write Count | This metric indicates 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 indicates 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 indicates the number of times database files are written per second. | ≥ 0 | count/s | Data Warehouse Cluster | 4 minutes |
dws007_db_size |
Data Size | This metric indicates 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 indicates the number of currently active SQLs in the database. | ≥ 0 | count | Data Warehouse Cluster | 4 minutes |
dws009_session_count |
Session Count | This metric indicates the number of currently active connections to the database. | ≥ 0 | count | Data Warehouse Cluster | 4 minutes |
dws009_session_count |
Session Count | This metric indicates the number of currently active connections to the database. | ≥ 0 | count | Data Warehouse Cluster | 4 minutes |
dws010_cpu_usage |
CPU Usage | This metric is used to count the CPU usage of each cluster node. | 0%~100% | % | Data Warehouse Node | 1 minute |
dws011_mem_usage |
Memory Usage | This metric is used to count the memory usage of each cluster node. | 0%~100% | % | Data Warehouse Node | 1 minute |
dws012_iops |
IOPS | This metric is used to count 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 is used to count the total amount of data input from the network to each cluster node per second. | ≥ 0 bytes/second | byte/s | Data Warehouse Node | 1 minute |
dws014_bytes_out |
Network Output Throughput | This metric is used to count 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 Utilization | This metric is used to count the disk usage of each cluster node. | 0%~100% | % | Data Warehouse Node | 1 minute |
dws016_disk_total_size |
Disk Total Size | This metric is used to count 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 is used to count 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 is used to count the amount of data read per second from the data disk of each cluster node. | ≥ 0 bytes/second | byte/s | Data Warehouse Node | 1 minute |
dws019_disk_write_throughput |
Disk Write Throughput | This metric is used to count the amount of data written per second to the data disk of each cluster node. | ≥ 0 bytes/second | byte/s | Data Warehouse Node | 1 minute |
dws020_avg_disk_sec_per_read |
Disk Read Latency | This metric is used to count the average time taken to read data 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 is used to count the average time taken to write data 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 is used to count the average I/O queue length of the data disk of each cluster node. | ≥ 0 | count | Data Warehouse Node | 1 minute |
Objects¶
After data is synchronized normally, you can view the data in Guance'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 ```