6 Replies Latest reply on Mar 18, 2016 5:01 AM by bublik.ms

    Undersized/Oversized Hosts

    bardeev

      Hello.

       

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

      Help me change this formula for hosts.

        • Re: Undersized/Oversized Hosts
          jemertz

          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=…

          • Re: Undersized/Oversized Hosts
            Milan_Volejnik

            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
            2 of 2 people found this helpful
              • Re: Undersized/Oversized Hosts
                bardeev

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

                  • Re: Undersized/Oversized Hosts
                    Milan_Volejnik

                    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

                      • Re: Undersized/Oversized Hosts
                        bardeev

                        Thanks,

                        But we need something like a report with recomendation.

                        • Re: Undersized/Oversized Hosts
                          bublik.ms

                          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