• Cloud Eye

ces
  1. Help Center
  2. Cloud Eye
  3. User Guide
  4. Services Supported by Cloud Eye
  5. Data Analysis
  6. DWS Metrics

DWS Metrics

Table 1 DWS metrics

Metric

Description

Value Range

Object

Monitoring Period (Raw Data)

Shared Memory Hit Ratio

Percentage of data volume obtained from memory

Unit: Percent

0-100%

Data warehouse clusters

1 minute

In-memory Sort Ratio

Percentage of data volume that is sorted in memory

Unit: Percent

0-100%

1 minute

File Reads

Total number of database file reads

> 0

1 minute

File Writes

Total number of database file writes

> 0

1 minute

File Reads per Second

Number of database file reads per second

≥ 0

1 minute

File Writes per Second

Number of database file writes per second

≥ 0

1 minute

Data Volume

Total data volume of the database

Unit: MB

0-36000 MB

1 minute

Active SQL Count

Number of active SQLs in the database

Unit: None

≥ 0

1 minute

Session Count

Number of sessions that access the database

Unit: None

≥ 0

1 minute

CPU Usage

CPU Usage of each node in the cluster

Unit: Percent

0-100%

Nodes in the cluster

1 minute

Memory Usage

Memory Usage of each node in the cluster

Unit: Percent

0-100%

1 minute

IOPS

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

≥ 0

1 minute

Network Input Throughput

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

Unit: byte/s

≥ 0 bytes/s

1 minute

Network Output Throughput

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

Unit: byte/s

≥ 0 bytes/s

1 minute

Disk Usage

Disk Usage of each node in the cluster

Unit: Percent

0-100%

1 minute

Total Disk Size

Total disk space of each node in the cluster

Unit: GB

100-2000 GB

1 minute

Disk Usage

Used disk space of each node in the cluster

Unit: GB

0-3600 GB

1 minute

Disk Read Throughput

Data volume read from each disk in the cluster per second

Unit: byte/s

≥ 0 bytes/s

1 minute

Disk Write Throughput

Data volume write to each disk in the cluster per second

Unit: byte/s

≥ 0 bytes/s

1 minute

Average Time per Disk Read

Average time used each time when a disk reads data

Unit: Second

> 0s

1 minute

Average Time per Disk Write

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

Unit: Second

> 0s

1 minute

Average Disk Queue Length

Average I/O queue length of a disk

≥ 0

1 minute