23.3.02 OEM View - Infrastructure
The BMC Helix Continuous Optimization OEM View - Infrastructure page is designed for presenting the capacity status of the cluster database and its database servers. It contains two tabs:
Database Clusters for Cluster database entities and database server entities. Each tab has a overview table to show the status of the entities.
Database Clusters Tab
Database Clusters tab shows the Cluster database entities. In the summary page, there's a Database Clusters table.
The table below summarize the information that is provided by the tab, by selecting hidden columns, you can see all the provided columns:
Column Name | Description | Source Metrics or Calculation |
|---|---|---|
Database Cluster | Cluster name, this is the link to the detailed page of each cluster | Entname |
Software Version | Version of the database product | SOFTWARE_VER [LASTVAL] |
CPU Clock Frequency [MHz] | CPU Core Frequency in MHz | CPU_MHZ [LASTVAL] |
Total Memory [GB] | Total real memory in GB | TOTAL_REAL_MEM [LASTVAL] |
CPU UTIL PCT [%] | CPU Utilization percentage | CPU_UTIL [95th] |
MEM Util Pct [%] | Memory Utilization percentage | MEM_UTIL [95th] |
Active Memory Utilization % | Active memory utilization percentage | ACTIVE_MEM/TOTAL_REAL_MEM |
MEM REAL UTIL PCT [%] | Real Memory Utilization percentage | MEM_REAL_UTIL [95th] |
CPU UTIL SYSTEM PCT | CPU Utilization in system time | CPU_UTIL_SYSTEM [95th] |
CPU UTIL USER PCT | CPU Utilization in user time | CPU_UTIL_USER [95th] |
CPU UTIL WAIO PCT | CPU Utilization in waiting time for IO | CPU_UTIL_WAIO [95th] |
Days to Saturation | Number of days before the Database Cluster will breach thresholds for CPU or Memory Utilization |
This is a screenshot of the summary table:
Database Cluster - Detail page
By clicking each cluster name, the database cluster - detail page is shown:
In this detail page, there are two metrics trend chart
- CPU Utilization (CPU_UTIL)
- Memory Utilization (MEM_UTIL)
There's a link "Database Server" to Database Server summary pages which shows all database servers that are in the cluster.
This is a screenshot of the Database Cluster Detail page:
Database Server Tab
Database Server tab shows the Cluster database entities. In the summary page, there's a Database Servers table.
The table below summarize the information that is provided by the tab, by selecting hidden columns, you can see all the provided columns:
Column Name | Description | Source Metrics or Calculation |
|---|---|---|
Database Server | Database server name, this is the link the detailed page of each server | Entname |
Database Cluster | Cluster name, this is the link to the detailed page of each cluster | Cluster name |
Software Version | Version of the database product | Cluster's SOFTWARE_VER [LASTVAL] |
Number of CPU cores | Total number of CPU Cores | CPU_NUM [LASTVAL] |
CPU Clock Frequency [MHz] | CPU Core Frequency in MHz | CPU_MHZ [LASTVAL] |
CPU Run Queue Length | CPU Run Queue Length | CPU_RUN_QUEUE [LASTVAL] |
Total Memory [GB] | Total real memory in GB | TOTAL_REAL_MEM [LASTVAL] |
CPU UTIL PCT [%] | CPU Utilization percentage | CPU_UTIL [95th] |
MEM Util Pct [%] | Memory Utilization percentage | MEM_UTIL [95th] |
Active Memory Utilization % | Active memory utilization percentage | ACTIVE_MEM/TOTAL_REAL_MEM |
MEM REAL UTIL PCT [%] | Real Memory Utilization percentage | MEM_REAL_UTIL [95th] |
CPU UTIL SYSTEM PCT | CPU Utilization in system time | CPU_UTIL_SYSTEM [95th] |
CPU UTIL USER PCT | CPU Utilization in user time | CPU_UTIL_USER [95th] |
CPU UTIL WAIO PCT | CPU Utilization in waiting time for IO | CPU_UTIL_WAIO [95th] |
Memory Swap Out Byte Rate | Memory Swap Out rate in bytes per second | MEM_SWAP_OUT_BYTE_RATE[95th] |
Disk Service Time [msec] | Disk service time in milisecond | DISK_SVC_TIME [95th] |
Disk IO RATE [request/s] | Disk Average I/O Rate aggregated by host | DISK_IO_RATE [95th] |
Days to Saturation | Number of days before the Database Server will breach thresholds for CPU or Memory Utilization |
This is a screenshot of the summary table:
Database Server- Detail page
By clicking each cluster name, the database cluster - detail page is shown:
In this detail page, there are two metrics trend chart
- CPU Utilization (CPU_UTIL)
- Memory Utilization (MEM_UTIL)
- By Network Analysis Top 10 (BYIF_UTIL)
- Disk (DISK_IO_RATE)
- BYDISK BUSY TIME (TOP 10) BYDISK_QUEUE_TIME)
- By Logical Disk Space % (Top 10) (BYLDISK_USED_SPACE_PCT)
This is a screenshot of the Database Server Detail page:
