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:
Milan
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.