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.
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:
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:
vm.cpuCount:[2 TO *] AND vm.powerstate:poweredOn AND vm.cpuloadSumpeak.month:[0 TO 20]
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.powerstate:poweredOn AND vm.memload.month:[60 TO *]
vm.memory:[2048 TO *] AND vm.powerstate:poweredOn AND vm.consumedPercentMemload.month:[0 TO 30]
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:
datastore.capacityDepletionDate:[* TO 2016.05.01]
Predicted VM Disk Depletion:
vm.powerstate:poweredOn AND vm.vol.capacityDepletionDate:[* TO 2016.05.01]
Free Space: sum(/virtualMachine/diskVolume/freeSpace)
vm.vdisk.name: vm.vdisk.name
Capacity: sum(/virtualMachine/diskVolume/capacity)
Cluster: vm.cluster.name
