This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Undersized/Oversized Hosts

Hello.

In Virtualization Manager is a formula to calculate the Undersized/Oversized VMs.

Help me change this formula for hosts.

  • You can modify the way capacity is calculated in the Calculation Settings.
    See page 166 of the Virtualization Manager Administrator Guide for more info: http://www.solarwinds.com/documentation/vMan/docs/pdf/en-US/SolarWinds_Virtualization_Manager_Admin_Guide.pdf?CMPSource=…

  • Apparently all attributes used in the search queries are also available to Hosts. So for example "Oversized VMs" trend

    vm.powerstate:poweredOn AND ((vm.cpuloadSumpeak.week:[0 TO 30] AND vm.cpuCount:[2 TO *]) OR (vm.memloadPeak.week:[0 TO 30] AND vm.memory:[2048 TO *]))

    can be rewritten to

    host.powerstate:poweredOn AND ((host.cpuloadSumpeak.week:[0 TO 30] AND host.cpuCount:[2 TO *]) OR (host.memloadPeak.week:[0 TO 30] AND host.memory:[2147483648 TO *]))

    Important note: vm.memory attribute shows memory in [MB], whereas host.memory is in [B]. That's why it's necessary to replace 2048 with 2147483648.

    I'd also recommend usage of "Host memory utilization" and "Host CPU utilization" alerts. You can find them in Explore - Content menu.

    2147483648
  • Thanks!!!

    And one more question, the recommendations still the same?

    Or there is another method of calculation?

    CPU Underallocated:

    if (/virtualMachine/cpuCount < 16) then concat('Increase ', /virtualMachine/cpuCount, ' to ', (if ((/virtualMachine/cpuCount * /virtualMachine/cpuUtilization/week/text()) < 140) then 2 else if ((/virtualMachine/cpuCount * /virtualMachine/cpuUtilization/week/text()) < 280) then 4 else if ((/virtualMachine/cpuCount * /virtualMachine/cpuUtilization/week/text()) < 560) then 8 else 16)) else 'Reduce load'

    CPU Overallocated:

    concat('Reduce ', /virtualMachine/cpuCount, ' to ', (if ((/virtualMachine/cpuCount * /virtualMachine/cpuUsedPeakUtilization/week/text()) <= 80) then 1 else if ((/virtualMachine/cpuCount * /virtualMachine/cpuUsedPeakUtilization/week/text()) <= 160) then 2 else if ((/virtualMachine/cpuCount * /virtualMachine/cpuUsedPeakUtilization/week/text()) <= 320) then 4 else 8))

    VM Memory Underallocated:

    concat('Increase ', /virtualMachine/memory, ' MB to ', /virtualMachine/memory * 2, ' MB')

    VM Memory Overallocated:

    if(floor(/virtualMachine/consumedMemoryUtilization/week div 1024 * 1.5) < 256) then concat('Reduce ', /virtualMachine/memory, ' MB to 256 MB') else concat('Reduce ', /virtualMachine/memory, ' MB to ', floor(/virtualMachine/consumedMemoryUtilization/week div 1024 * 1.5), ' MB')

  • Hi,

    there's no such recommendation for Hosts. As I recommended above, there are "Host memory utilization" and "Host CPU utilization" alerts. Such alerts should tell you that you have lack of resources.

    Or you can also use "Capacity Planner" to get an overview if/when the hosts or clusters will run out of resources:
    pastedImage_7.png

    Milan

  • Thanks,

    But we need something like a report with recomendation.

  • I have the same problem. My widgets by VMs, but i need by Hosts. SolarWinds Virtualization manager have settings sort by

    type: VM and type: Host (in the screenshot).

    How change formuls to calculate hosts?

    My formuls in the widgets:

    VM CPU Underallocated:

    This formula in "Query":

    vm.cpuload.month:[70 TO *] AND vm.powerstate:poweredOn

    This formula in "Columns":

    if (/virtualMachine/cpuCount < 16) then concat('Increase ', /virtualMachine/cpuCount, ' to ', (if

    ((/virtualMachine/cpuCount * /virtualMachine/cpuUtilization/text()) < 140) then 2 else if ((/virtualMachine/cpuCount *

    /virtualMachine/cpuUtilization/text()) < 280) then 4 else if ((/virtualMachine/cpuCount *

    /virtualMachine/cpuUtilization/text()) < 560) then 8 else 16)) else 'Reduce load'

    =============================

    VM CPU Overallocated:

    This formula in "Query":

    vm.cpuCount:[2 TO *] AND vm.powerstate:poweredOn AND vm.cpuloadSumpeak.month:[0 TO 20]

    This formula in "Columns":

    concat('Reduce ', /virtualMachine/cpuCount, ' to ', (if ((/virtualMachine/cpuCount *

    /virtualMachine/cpuUsedPeakUtilization/month/text()) <= 80) then 1 else if ((/virtualMachine/cpuCount *

    /virtualMachine/cpuUsedPeakUtilization/month/text()) <= 160) then 2 else if ((/virtualMachine/cpuCount *

    /virtualMachine/cpuUsedPeakUtilization/month/text()) <= 320) then 4 else 8))

    ============================

    VM Memory Underallocated:

    This formula in "Query":

    vm.powerstate:poweredOn AND vm.memload.month:[60 TO *]

    This formula in "Columns":

    concat('Increase ', /virtualMachine/memory, ' MB to ', /virtualMachine/memory * 2, ' MB')

    ============================

    VM Memory Overallocated:

    This formula in "Query":

    vm.memory:[2048 TO *] AND vm.powerstate:poweredOn AND vm.consumedPercentMemload.month:[0 TO 30]

    This formula in "Columns":

    if(floor(/virtualMachine/consumedMemoryUtilization/month div 1024 * 1.5) < 256) then concat('Reduce ',

    /virtualMachine/memory, ' MB to 256 MB') else concat('Reduce ', /virtualMachine/memory, ' MB to ', floor

    (/virtualMachine/consumedMemoryUtilization/month div 1024 * 1.5), ' MB')

    ============================

    Predicted Datastore Space Depletion:

    This formula in "Query":

    datastore.capacityDepletionDate:[* TO 2016.05.01]

    ============================

    Predicted VM Disk Depletion:

    This formula in "Query":

    vm.powerstate:poweredOn AND vm.vol.capacityDepletionDate:[* TO 2016.05.01]

    This formula in "Columns":

    Free Space: sum(/virtualMachine/diskVolume/freeSpace)

    vm.vdisk.name: vm.vdisk.name

    Capacity: sum(/virtualMachine/diskVolume/capacity)

    Cluster: vm.cluster.name

    VM to Hosts.png

    VM to Hosts - 2.png