Out-of-the-box data marts for recommendations
The following table lists the out-of-the-box data marts that provide recommendations output for supported technologies. You can use these data marts to create a custom dashboard in BMC Helix Dashboards to view the recommendations data provided in BMC Helix Continuous Optimization.
ID | Data mart name | Identifier | Description | Entities |
|---|---|---|---|---|
1730 | ER_V_RECOMM_VM_OVERALLOCATED | Contains VMs that are overallocated for CPU, Memory, or Storage resources. | VMware VMs, Hyper-V VMs, AWS Instances, Azure Instances | |
1732 | ER_V_RECOMM_IDLE_VM | Contains VMs that are Idle based on low or no resource consumption. | VMware VMs, Hyper-V VMs, AWS Instances, Azure Instances, GCP Instances | |
1731 | ER_V_RECOMM_FORECASTED_SAT | Contains clusters, hosts, or VMs that are already saturated or are forecasted to saturate within the next 90 days. | VMware - Clusters, VMware - Hosts, VMware - Datastore Clusters VMware - Datastores, VMware - Virtual Machines, Solaris - LDOM, Solaris - LDOM File System Used | |
200252 | ER_V_RECOMM_CLUSTER_OVERSUBS | Contains clusters that are oversubscribed. | VMware Clusters, Kubernetes Clusters | |
200250 | ER_V_RECOMM_OVERALLOC_CONT | Contains Kubernetes containers that are overallocated for CPU or Memory resources. | Kubernetes Containers | |
200251 | ER_V_RECOMM_SATURATION_CONT | Contains Kubernetes containers that are already saturated or are forecasted to saturate within the next 90 days. | Kubernetes Containers | |
200253 | ER_V_RECOMM_FORECASTED_K8_INFR | Contains Kubernetes clusters, hosts, or namespaces that are either saturated or are forecasted to saturate within the next 90 days. | Kubernetes Clusters, Kubernetes Nodes, Kubernetes Namespaces |
Review the following tables to learn the column details in each of these out-of-the-box data marts.
RECOMM_VM_OVERALLOCATE
Column name | Description |
|---|---|
sysId | ID of the entity |
name | Name of the entity |
systype | Type of the entity |
recommended_cpu [cores] | Recommended CPU in cores to prevent overallocation |
cpu_spare_threshold | Allocated CPU headroom, in addition to the CPU demand, when calculating the recommended CPU. The spare CPU threshold in cores is set from the Administration > Optimizer > Rules page for each platform. |
recommended_memory [GB] | Recommended Memory in GB to prevent overallocation |
memory_spare_threshold | Allocated memory headroom, in addition to the memory demand, when calculating the recommended memory. The Spare memory threshold in GB is set from the Administration > Optimizer > Rules page for each platform. |
recommended_storage [GB] | Recommended Storage in GB to prevent overallocation |
fs_spare_threshold | Allocated storage headroom, in addition to the storage demand, when calculating the recommended storage. The Spare storage threshold in GB is set from the Administration > Optimizer > Rules page for each platform. |
current_CPU [cores] | Current value of the CPU configured for the VM |
current_memory [GB] | Current value of Memory configured for the VM |
current_Storage [GB] | Current value of Storage configured for the VM |
current_CPU_util [% decimal] | Current (last value) of CPU Utilization in percentage |
recommended_CPU_Util [% decimal] | CPU Utilization calculated based on the recommended CPU |
recommended_cpu_util_30d | CPU Utilization calculated based on CPU recommended in the next 30 days. |
current_Memory_Util [% decimal] | Current (last value) of Memory Utilization in percentage |
recommended_Memory_Util [% decimal] | Memory Utilization calculated based on recommended Memory |
recommended_memory_util_30d | Memory Utilization calculated based on memory recommended in the next 30 days. |
IND_CPU_DEMAND | An estimate of the CPU demand1 |
IND_MEMORY_DEMAND | An estimate of the memory demand1 |
IND_STORAGE_DEMAND | An estimate of the storage demand1 |
current_storage_util | Current (last value) of Storage Utilization in percentage |
recommended_storage_util | Storage Utilization calculated based on recommended Storage |
recommended_storage_util_30d | Storage Utilization calculated based on storage recommended in the next 30 days. |
1 For details about these columns, see Indicators.
RECOMM_IDLE_VM
Column name | Description |
|---|---|
sysid | ID of the entity |
name | Name of the entity |
systype | Type of the entity |
idle_days | Number of days the VM has been idle within the last 90 days based on the criteria specified in the Optimizer Rule. |
idle_days_threshold | Threshold for the number of days of inactivity beyond which the VM is considered Idle. |
uptime_days | Number of days the VM has been up (powered ON state) during the last 90 days. |
power_off_days | Number of days the VM has been powered off during the last 90 days. |
storage_size[GB] | Current value of storage configured for the VM |
cpu_num[cores] | Current value of CPU cores configured for the VM |
total_real_memory[GB] | Current value of memory configured for the VM |
RECOMM_FORECASTED_SATURATION
Column name | Description |
|---|---|
sysid | ID of the entity |
name | Name of the entity |
systype | Type of the entity |
global_days_to_saturation | An estimate of the number of days in which one of the resources will saturate1 |
global_warning_threshold | Configuration metric specified in number of days. Resources saturating within the number of days specified in this parameter are categorized in the warning state. |
cpu_days_to_saturation | An estimate of the number of days in which CPU will saturate1 |
memory_days_to_saturation | An estimate of the number of days in which memory will saturate1 |
storage_days_to_saturation | An estimate of the number of days in which storage will saturate1 |
cpu_conf_value[cores] | Current value of CPU cores configured |
global_critical_threshold | Configuration metric specified in number of days. Resources saturating within the number of days specified in this parameter are categorized in the critical state. |
cpu_saturation_starting_value | The value of CPU usage from which the forecast is projected. This is the last value of the CPU usage time series. |
cpu_threshold_dec_value | Threshold for CPU saturation expressed in a decimal value of the percentage. |
cpu_short_term_forecast | Recommended CPU to prevent saturation in the next 30 days. |
cpu_threshold_absolute_value | Threshold for CPU saturation expressed in absolute core units |
cpu_long_term_forecast | Recommended CPU to prevent saturation in the next 90 days. |
long_term_threshold | Number of days for which the long-term forecast is calculated. Currently, this value is set to 90 days. |
cpu_slope | Slope value that indicates the daily rate of change in CPU. |
memory_short_term_forecast | Recommended memory to prevent saturation in the next 30 days. |
memory_conf_value[GB] | Current value of memory configured in GB |
memory_threshold_absolute_value | Threshold for memory saturation expressed in absolute GB units. |
memory_long_term_forecast | Recommended memory to prevent saturation in the next 90 days. |
memory_slope | Slope value that indicates the daily rate of change in memory. |
memory_saturation_starting_value | The value of memory usage from which the forecast is projected. This is the last value of the memory usage time series. |
memory_threshold_dec_value | Threshold for memory saturation expressed in a decimal value of the percentage. |
storage_conf_value[GB] | Current value of storage configured in GB |
storage_saturation_starting_value | The value of storage usage from which the forecast is projected. This is the last value of the storage usage time series. |
storage_short_term_forecast | Recommended storage to prevent saturation in the next 30 days. |
storage_threshold_absolute_value | Threshold for storage saturation expressed in absolute GB units. |
storage_long_term_forecast | Recommended storage to prevent saturation in the next 90 days. |
storage_threshold_dec_value | Threshold for storage saturation expressed in a decimal value of the percentage. |
storage_slope | Slope value that indicates the daily rate of change in storage. |
cpu_threshold_pct_value | Threshold for CPU saturation expressed in percentage. |
memory_threshold_pct_value | Threshold for memory saturation expressed in percentage. |
storage_threshold_pct_value | Threshold for storage saturation expressed in percentage. |
1 For details about these columns, see Indicators.
RECOMM_CLUSTER_OVERSUBSCRIPTION
Column name | Description |
|---|---|
sysid | ID of the entity |
name | Name of the entity |
systype | Type of the entity |
overallocated_vms_count | Number of VMs that are overallocated |
cpu_density | Ratio of the sum number of vCPUs configured for the VMs to the number of physical CPUs available in the cluster1 |
cpu_density_threshold | Good threshold value for CPU density or oversubscription specified by using Administrator > Optimizer thresholds page. |
memory_oversubscription | Ratio of the sum of memory configured for the VMs to the total memory available in the cluster1 |
memory_oversubscription_threshold | Good threshold value for memory oversubscription specified by using Administrator > Optimizer thresholds page. |
storage_oversubscription | Ratio of the sum of the storage provisioned for the VMs to the number of datastore capacity available in the cluster1 |
storage_oversubscription_threshold | Good threshold value for storage oversubscription specified by using Administrator > Optimizer thresholds page. |
cpu_num | Current number (last value) of physical CPUs available in the cluster. |
cpu_request | Requested CPU cores for the cluster. It is the sum of the CPU requests of the containers running in this cluster. CPU request of a container is the amount of CPU that the system will guarantee for a container. |
cpu_limit | CPU Limit of the cluster. It is the sum of the CPU limit of the containers running in this cluster. CPU limit of a container is the maximum amount of CPU that the container is allowed to use. |
cpu_util_vs_request | Percentage of CPU used with respect to the CPU request. |
cpu_util_vs_limit | Percentage of CPU used with respect to the CPU limit. |
total_real_mem | Current total memory (last value) available in the cluster. |
mem_request | Requested memory for the cluster. It is the sum of the memory requests of the containers running in this cluster. The memory request of a container is the amount of memory that the system will guarantee for a container. |
mem_klimit | Memory Limit of the cluster. It is the sum of the memory limit of the containers running in this cluster. The memory limit of a container is the maximum amount of memory that the container is allowed to use. |
mem_util_vs_request | Percentage of memory used with respect to memory request. |
mem_util_vs_limit | Percentage of memory used with respect to memory limit. |
kpod_num | Number of pods in the cluster. |
cpu_density_warning_threshold | Warning threshold value for CPU density or oversubscription specified by using Administrator > Optimizer thresholds page. |
memory_over_commitment_warning_threshold | Warning threshold value for memory oversubscription specified by using Administrator > Optimizer thresholds page. |
1 For details about these columns, see Indicators.
RECOMM_KUBERNETES_OVERALLOCATED_CONTAINERS
Column name | Description |
|---|---|
sysid | ID of the entity |
name | Name of the entity |
systype | Type of the entity |
cpu_request | CPU request configured for the container. It is the amount of CPU (mcores) that will be guaranteed for the container. |
cpu_request_demand | CPU demand scaled based on the CPU request of the container. It is calculated by using the 75th percentile value of the granular samples of container usage data. |
recommended_cpu_request | CPU requests recommended to avoid the overallocation of resources to the container and save costs by reclaiming resources. |
cpu_limit | CPU limit configured for the container. It is the amount of CPU (mcores) that the container will be allowed to use. |
cpu_limit_demand | CPU demand scaled based on the CPU limit of the container. CPU demand peak is calculated using the 95th percentile value of the granular samples of container usage data. |
recommended_cpu_limit | Recommended CPU limit corresponding to the increase in the recommended CPU request for the container. |
cpu_headroom | A configuration parameter that specifies the percentage of configured CPU that should be reserved when calculating CPU overallocation. |
memory_headroom | A configuration parameter that specifies the percentage of configured memory that should be reserved when calculating memory overallocation. |
memory_request | Memory request configured for the container. It is the amount of memory that the system will guarantee for a container. |
memory_request_demand | Memory demand scaled based on the memory request of the container. It is calculated by using the 75th percentile value of the granular samples of container usage data. |
recommended_memory_request | Memory requests recommended to avoid the overallocation of resources to the container and save costs by reclaiming resources. |
memory_limit | Memory limit configured for the container. It is the maximum amount of memory that the container is allowed to use. Container will be terminated if it tries to allocate more memory than the configured limit. |
memory_limit_demand | Memory demand scaled based on the memory limit of the container. Memory demand peak is calculated using the 95th percentile value of the granular samples of container usage data. |
recommended_memory_limit | Recommended memory limit corresponding to the increase in the recommended CPU request for the container. |
global_jvm_max_heap | Maximum JVM Heap size configured for the Java applications running inside the container. |
global_jvm_heap_demand | JVM heap demand computed based on the heap memory usage. |
recommended_global_jvm_max_heap | Recommended Java Virtual Machine Maximum Heap size to make sure that the application will run with optimal performance without wasting memory resources, expressed in MB. |
recommended_global_jvm_max_heap_pct | Recommended Java Virtual Machine Maximum Heap size to make sure that the application will run with optimal performance without wasting memory resources, expressed as a percentage of the configured max heap size. |
kpod_num | Number of replicas configured for the Pod where the container is running. |
RECOMM_FORECASTED_SATURATION_CONTAINERS
Column name | Description |
|---|---|
sysid | ID of the entity |
name | Name of the entity |
systype | Type of the entity |
cpu_days_to_saturation | An estimate of the number of days in which CPU will saturate1 |
cpu_request | CPU request configured for the container. It is the amount of CPU (mcores) that will be guaranteed for the container. |
cpu_used_vs_request | CPU used with respect to the CPU request of the container |
recommended_cpu_request | Recommended CPU requests to avoid saturation |
cpu_limit | CPU limit configured for the container. It is the amount of CPU (mcores) that the container will be allowed to use. |
cpu_used_vs_limit | CPU used with respect to the CPU limit of the container |
recommended_cpu_limit | Recommended CPU limit corresponding to the increase in the recommended CPU request for the container. |
cpu_limit_util | Last value of CPU usage in cores |
daily_cpu_trend | Daily rate of change in CPU usage |
memory_request | Memory request configured for the container. It is the amount of memory that the system will guarantee for a container. |
memory_request_demand | An estimate of the memory demand that is based on memory usage with respect to the request of the container in the last 30 days. |
memory_used_vs_request | Memory used with respect to the memory request of the container. |
recommended_memory_request | Recommended memory request to avoid saturation. |
memory_limit | Maximum amount of memory that the container is allowed to use. Container will be terminated if it tries to allocate more memory than the configured limit. |
memory_limit_demand | An estimate of the memory demand that is based on memory usage with respect to the request of the container in the last 30 days. |
memory_used_vs_limit | Memory used with respect to the memory limit of the container. |
recommended_memory_limit | Recommended memory limit corresponding to the increase in the recommended memory request for the container. |
global_jvm_max_heap | Maximum JVM Heap size configured for the Java applications running inside the container. |
global_jvm_heap_demand | JVM heap demand computed based on the heap memory usage. |
recommended_global_jvm_max_heap | Recommended Java Virtual Machine Maximum Heap size to make sure that the application will run with optimal performance without wasting memory resources expressed in MB. |
recommended_global_jvm_max_heap_pct | Recommended Java Virtual Machine Maximum Heap size to make sure that the application will run with optimal performance without wasting memory resources expressed as a percentage of the configured max heap size. |
global_warning_threshold | Configuration metric specified in number of days. Resources saturating within the number of days specified in this parameter are categorized in the warning state. |
global_critical_threshold | Configuration metric specified in number of days. Resources saturating within the number of days specified in this parameter are categorized in the critical state. |
short_term_threshold | Number of days for which the short-term forecast is calculated. This value is set to 30 days. |
long_term_threshold | Number of days for which the long-term forecast is calculated. This value is set to 90 days. |
cpu_utilization_threshold | Absolute value of CPU threshold |
cpu_utilization_threshold_pct | Percentage value of CPU threshold |
cpu_short_term_recomm | Recommended CPU to prevent saturation in the next 30 days. |
cpu_long_term_recomm | Recommended CPU to prevent saturation in the next 90 days. |
global_days_to_saturation | An estimate of the number of days in which the least available resource (CPU or Memory) will saturate1 |
mem_utilization_threshold | Absolute value of memory threshold |
mem_utilization_threshold_pct | Percentage value of memory threshold |
memory_days_to_saturation | An estimate of the number of days in which memory will saturate1 |
memory_short_term_recomm | Recommended memory to prevent saturation in the next 30 days. |
memory_long_term_recomm | Recommended memory to prevent saturation in the next 90 days. |
daily_mem_trend | Daily rate of change in memory usage |
kpod_num | Number of pods in the cluster. |
1 For details about these columns, see Indicators.
RECOMM_FORECASTED_K8_INFRA
Column name | Description |
|---|---|
sysid | ID of the entity |
name | Name of the entity |
systype | Type of the entity |
global_days_to_saturation | An estimate of the number of days in which one of the resources will saturate1 |
cpu_days_to_saturation | An estimate of the number of days in which CPU will saturate1 |
memory_days_to_saturation | An estimate of the number of days in which memory will saturate1 |
storage_days_to_saturation | An estimate of the number of days in which storage will saturate1 |
cpu_conf_value | Current value of memory configured in cores |
cpu_saturation_starting_value | Value of CPU usage from which the forecast is projected. This is the last value of the cpu usage time series. |
cpu_short_term_forecast | Recommended CPU to prevent saturation in the next 30 days. |
cpu_long_term_forecast | Recommended CPU to prevent saturation in the next 90 days. |
cpu_slope | Slope value that indicates the daily rate of change in CPU |
memory_short_term_forecast | Recommended memory to prevent saturation in the next 30 days. |
memory_conf_value | Current value of memory configured in GB |
memory_long_term_forecast | Recommended CPU to prevent saturation in the next 90 days. |
memory_slope | Slope value that indicates the daily rate of change in memory |
memory_saturation_starting_value | Value of memory usage from which the forecast is projected. This is the last value of the memory usage time series. |
storage_conf_value | Current value of storage configured in GB |
storage_saturation_starting_value | Value of storage usage from which the forecast is projected. This is the last value of the storage usage time series. |
storage_short_term_forecast | Recommended storage to prevent saturation in the next 30 days. |
storage_long_term_forecast | Recommended CPU to prevent saturation in the next 90 days. |
storage_slope | Slope value that indicates the daily rate of change in storage |
global_warning_threshold | Configuration metric specified in number of days. Resources saturating within the number of days specified in this parameter are categorized in a warning state. |
cpu_used | CPU used by the cluster/node/namespace. |
cpu_request | Sum of the CPU request configured for the containers in the cluster/Node/Namespace. |
global_critical_threshold | Configuration metric specified in number of days. Resources saturating within the number of days specified in this parameter are categorized in a critical state. |
cpu_threshold_pct_value | Percentage value of the CPU threshold. |
cpu_threshold_absolute_value | Absolute value of the CPU threshold |
long_term_threshold | Number of days for which the long-term forecast is calculated. Currently, this value is set to 90 days. |
cpu_limit | Sum of the CPU limit configured for the containers in the cluster/Node/Namespace. |
dts_memory_usage_metric | Memory usage metric of the cluster/Node/Namespace that is used for days to saturation calculation. |
memory_threshold_absolute_value | Absolute value of memory threshold |
mem_request | Sum of the memory request configured for the containers in the cluster/Node/Namespace. |
memory_threshold_pct_value | Percentage value of memory threshold |
mem_klimit | Sum of the memory limit configured for the containers in the cluster/Node/Namespace |
storage_used | Storage used by the cluster/node/namespace |
storage_threshold_absolute_value | Absolute value of storage threshold |
storage_threshold_pct_value | Percentage value of storage threshold |
1 For details about these columns, see Indicators.