Skip to content

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)

  1. Log in to the Func console, click on 【Script Market】, and enter the TrueWatch Script Market to search for integration_huaweicloud_dws.

  2. Click 【Install】, then input the corresponding parameters: Huawei Cloud AK, SK, and account name.

  3. Click 【Deploy Startup Script】, the system will automatically create the Startup script set and configure the corresponding startup scripts.

  4. 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

  1. 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.
  2. In TrueWatch, check if there is asset information in 「Infrastructure - Resource Catalog」.
  3. 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 and fields may change with subsequent updates. ```