cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 11

Undersized/Oversized Hosts

Hello.

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

Help me change this formula for hosts.

6 Replies
Level 12

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
Level 11

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')

0 Kudos
Level 12

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

0 Kudos
Level 9

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

0 Kudos
Level 11

Thanks,

But we need something like a report with recomendation.

0 Kudos
Level 11

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_...