• Cloud Eye

ces
  1. Help Center
  2. Cloud Eye
  3. API Reference
  4. Appendix
  5. DWS Metrics

DWS Metrics

Function

This section describes metrics reported by the Data Warehouse Service (DWS) to Cloud Eye as well as their namespaces and dimensions. You can use APIs provided by Cloud Eye to query the metrics of the monitored object and alarms generated for DWS.

Namespace

SYS.DWS

Metrics

Metric

Name

Description

Value Range

Remarks

dws001_shared_buffer_hit_ratio

Cache Hit Ratio

Percentage of data volume obtained from memory

0-100%

Monitored object: data warehouse

Dimension:

datastore_id

dws002_in_memory_sort_ratio

In-memory Sort Ratio

Percentage of data volume that is sorted in memory

0-100%

Monitored object: data warehouse

Dimension:

datastore_id

dws003_physical_reads

File Reads

Total number of database file reads

≥ 0 times

Monitored object: data warehouse

Dimension:

datastore_id

dws004_physical_writes

File Writes

Total number of database file writes

≥ 0 times

Monitored object: data warehouse

Dimension:

datastore_id

dws005_physical_reads_per_second

File Reads per Second

Number of database file reads per second

≥ 0 times/s

Monitored object: data warehouse

Dimension:

datastore_id

dws006_physical_writes_per_second

File Writes per Second

Number of database file writes per second

≥ 0 times/s

Monitored object: data warehouse

Dimension:

datastore_id

dws007_db_size

Data Volume

Total data volume of the database

≥ 0 MB

Monitored object: data warehouse

Dimension:

datastore_id

dws008_active_sql_count

Active SQL Count

Number of active SQLs in the database

≥ 0

Monitored object: data warehouse

Dimension:

datastore_id

dws009_session_count

Session Count

Number of sessions that access the database

≥ 0

Monitored object: data warehouse

Dimension:

datastore_id

dws010_cpu_usage

CPU Usage

CPU usages of each node in the cluster

0-100%

Monitored object: data warehouse

Dimension:

dws_instance_id

dws011_mem_usage

Memory Usage

Memory usages of each node in the cluster

0-100%

Monitored object: data warehouse

Dimension:

dws_instance_id

dws012_iops

IOPS

Number of I/O requests processed by each node in the cluster per second

≥ 0

Monitored object: data warehouse

Dimension:

dws_instance_id

dws013_bytes_in

Network Input Throughput

Data input to each node in the cluster per second over the network

≥ 0 bytes/s

Monitored object: data warehouse

Dimension:

dws_instance_id

dws014_bytes_out

Network Output Throughput

Data sent to the network per second from each node in the cluster

≥ 0 bytes/s

Monitored object: data warehouse

Dimension:

dws_instance_id

dws015_disk_usage

Disk Utilization

Disk usages of each node in the cluster

0-100%

Monitored object: data warehouse

Dimension:

dws_instance_id

dws016_disk_total_size

Total Disk Size

Total disk space of each cluster node

≥ 0 GB

Monitored object: data warehouse

Dimension:

dws_instance_id

dws017_disk_used_size

Disk Usage

Used disk space of each node in the cluster

≥ 0 GB

Monitored object: data warehouse

Dimension:

dws_instance_id

dws018_disk_read_throughput

Disk Read Throughput

Data volume read by each disk in the cluster per second

≥ 0 bytes/s

Monitored object: data warehouse

Dimension:

dws_instance_id

dws019_disk_write_throughput

Disk Read Throughput

Data volume written to each disk per second

≥ 0 bytes/s

Monitored object: data warehouse

Dimension:

dws_instance_id

dws020_avg_disk_sec_per_read

Average Time per Disk Read

Average time used each time when a disk reads data

≥ 0s

Monitored object: data warehouse

Dimension:

dws_instance_id

dws021_avg_disk_sec_per_write

Average Time per Disk Write

Average time consumed by the disk to write data on cluster nodes

≥ 0s

Monitored object: data warehouse

Dimension:

dws_instance_id

dws022_avg_disk_queue_length

Average Disk Queue Length

Average time used each time when data is written to a disk

≥ 0

Monitored object: data warehouse

Dimension:

dws_instance_id

Dimension

Key

Value

datastore_id

Data Warehouse Service

dws_instance_id

Data warehouse node