• Spaces
  • Collections
  • Help
    • ×
     
     
    •  
    Moviri documentation for BMC Helix Capacity Optimization

    Page tree


    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 NameDescriptionSource Metrics or Calculation
    Database ClusterCluster name, this is the link to the detailed page of each clusterEntname
    Software VersionVersion of the database productSOFTWARE_VER [LASTVAL]
    CPU Clock Frequency [MHz]CPU Core Frequency in MHzCPU_MHZ [LASTVAL]
    Total Memory [GB]Total real memory in GBTOTAL_REAL_MEM [LASTVAL]
    CPU UTIL PCT [%]CPU Utilization percentageCPU_UTIL [95th]
    MEM Util Pct [%]Memory Utilization percentageMEM_UTIL [95th]
    Active Memory Utilization %Active memory utilization percentageACTIVE_MEM/TOTAL_REAL_MEM
    MEM REAL UTIL PCT [%]Real Memory Utilization percentageMEM_REAL_UTIL [95th]
    CPU UTIL SYSTEM PCTCPU Utilization in system timeCPU_UTIL_SYSTEM [95th]
    CPU UTIL USER PCTCPU Utilization in user timeCPU_UTIL_USER [95th]
    CPU UTIL WAIO PCTCPU Utilization in waiting time for IOCPU_UTIL_WAIO [95th]

    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 NameDescriptionSource Metrics or Calculation
    Database Server Database server name, this is the link the detailed page of each serverEntname
    Database ClusterCluster name, this is the link to the detailed page of each clusterCluster name
    Software VersionVersion of the database productCluster's SOFTWARE_VER [LASTVAL]
    Number of CPU coresTotal number of CPU CoresCPU_NUM [LASTVAL]
    CPU Clock Frequency [MHz]CPU Core Frequency in MHzCPU_MHZ [LASTVAL]
    CPU Run Queue LengthCPU Run Queue LengthCPU_RUN_QUEUE [LASTVAL]
    Total Memory [GB]Total real memory in GBTOTAL_REAL_MEM [LASTVAL]
    CPU UTIL PCT [%]CPU Utilization percentageCPU_UTIL [95th]
    MEM Util Pct [%]Memory Utilization percentageMEM_UTIL [95th]
    Active Memory Utilization %Active memory utilization percentageACTIVE_MEM/TOTAL_REAL_MEM
    MEM REAL UTIL PCT [%]Real Memory Utilization percentageMEM_REAL_UTIL [95th]
    CPU UTIL SYSTEM PCTCPU Utilization in system timeCPU_UTIL_SYSTEM [95th]
    CPU UTIL USER PCTCPU Utilization in user timeCPU_UTIL_USER [95th]
    CPU UTIL WAIO PCTCPU Utilization in waiting time for IOCPU_UTIL_WAIO [95th]
    Memory Swap Out Byte RateMemory Swap Out rate in bytes per secondMEM_SWAP_OUT_BYTE_RATE[95th]
    Disk Service Time [msec]Disk service time in milisecondDISK_SVC_TIME [95th]
    Disk IO RATE [request/s]Disk Average I/O Rate aggregated by hostDISK_IO_RATE [95th]

    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: 



    • No labels
    © Copyright 2005-2024 BMC Software, Inc. Use of this site signifies your acceptance of BMC’s Terms of Use . BMC, the BMC logo, and other BMC marks are assets of BMC Software, Inc. These trademarks are registered and may be registered in the U.S. and in other countries.