Super Auto Sizing

We have greatly enhanced our Automatic Sizing.  Auto goes through all the possible options (an option is a model with specific component combination) and finds the optimal solution (lowest net cost)

Certainly good to know and often is the best solution.  We find users want to “play” with the recommendation like

  • Increasing and decreasing nodes to see impact on the utilization dials.  Auto provides N+1 or N+2 but good to see impact of losing a node for example
  • Would a faster processor or more RAM help a compute intense workload mix?
  • How about impact of changing storage options?

In old days you had to go to Manual, make a change, hit apply and then see the impact.  If you want to play with say 10 different changes that is a LOT of effort

Now we have Super Auto !!!

Here is an Automatic Sizing and you see there is 6 nodes.  The one thing that is new is you see the Customize link.  Click on this and you will enter that Super Auto Zone

Here is Super Auto

Key things

  • You now have + and – buttons to increment and decrement the nodes and the resources.  In regards to resources
    • Cores – You increment or decrement with more or less overall specint.  We go through the product structure for that model
    • RAM, HDD, SSD – You increment or decrement with more or less capacity.  We go through the product structure for that model
  • Whenever you click a new sizing is done with that change in either the model or the node count.  The dials are updated
  • You see a cost delta vs optimal.  So you don’t have to go to Budgetary quote to realize relative cost change.  Here we added a node and it increased the expected net price by 15%.  It is approximate.  We have budgetary quote to get a better number
  • You see at the top, Sizer tells you it is now customized.  That will be recorded in the BOM too
  • Restore to Auto.  Here can just have Sizer go back to optimal.
  • Done.  Have fun clicking things and in the end can go with it

What about the product details when I make changes?  

Product component descriptions and quantities are too long to put in the UI by the buttons.  So we have you increment or decrement and you see the overall capacity (e.g. increase or decrease HDD).  However at any time you can look at the model description ( the i by the model) and get all that info

Scenario Actions (when sizing is near completion)

Once we have your sizing complete or near complete you can do the following with your sizing

In the upper left can click on the actions button:

 

For Salesforce Login: 

  • Clone Scenario – Can clone the scenario (copy of the scenario) with a unique name. Often this is done if want to leverage same scenario but make a few changes in workloads, models, etc.
  • Delete Scenario – This is used to delete the scenario. Do note it is NOT recoverable
  • Download BOM – Here a PDF is created with the recommendation, all the workload inputs, sizing details and detailed BOM.
  • Attach BOM to Opportunity – The BOM pdf for the scenario will be attached to the opportunity in salesforce.
  • Generate Budgetary Quote – The BOM is put into an excel file and shows list prices.
  • Generate Salesforce Quote – A quote can be created for the scenario BOM in salesforce for the opportunity linked to scenario.
  • Import RVTools output – This allows a RVtools output run in a customer environment to be imported into Sizer.

For My Nutanix Login:

  • Edit Scenario – Here can enter in assumptions that you have with the customer and that is kept in the BOM.
  • Clone Scenario – Can clone the scenario (copy of the scenario) with a unique name. Often this is done if want to leverage same scenario but make a few changes in workloads, models, etc.
  • Delete Scenario – This is used to delete the scenario. Do note it is NOT recoverable.
  • Download BOM – Here a PDF is created with the recommendation, all the workload inputs, sizing details and detailed BOM.
  • Generate a Budgetary Quote – The BOM is put into an excel file and shows list prices
  • Import RVTools output – This allows a RVtools output run in a customer environment to be imported into Sizer.

Rack View

There is a rack view that you can access within the scenario page.

To see the power requirements click on the upper right link

RVTool Import into Sizer

RVTools overview

RVtools is a leading tool to monitor VMware clusters.  It is an free tool, that runs on Windows (.Net 4 application), can query VMWare’s  VI (Virtual Infrastructure) API to get numerous attributes. The VI API is exposed as a Web service, running on both ESX Server and VirtualCenter Server systems.

As you can see from the screenshot below, the tool has a number of tabs capturing the details in tabular format.

Steps for using RVTool in Sizer

 

  • The NTNX SE or Partner SE  to install the supported version of RVtools from Robware on their laptop.  Alternatively, the customer often has it installed and gives the SE the final excel file.
    • If SE runs it on their laptop, they would need permission and cooperation with the customer to have it point to VCenter or ESX. User/password is needed and must not be blocked by a firewall.   This can be a big issue and so could be best to have the customer running RVtools.
    • If customer gives final excel output, SE still needs customer to agree that configuration can be shared.
    • The command line to run the tool and create the excel output is included in this document.
  • Once the SE has the Excel output, they will import it into Sizer which will group most of the  VMs into one of 25 profiles.
  • Sizer will then return an excel with a Sizer_summary tab which has key information but also what profile is applied or “not covered”
  • The user should review this with the customer and especially those not covered by a profile.  They are very high in either CPU or RAM or Total capacity. Do they need to be that high? If so the user would create custom workload.

Does Sizer accounts for all the VMs imported by RVTool?

No. Sizer corresponds to only those VMs for which the ‘covered’ column in RVTool summary report is ‘Yes’.

There are couple of parameters based on which some VMs might not be covered and Sizer does not size for these VMs.

        Powerstate flag

  • A customer may have many VMs and often some are defined but turned off are actually dormant.  Automatically sizing all VMs could cause Sizer to oversize the environment. Conversely, some of the VMs that are powered down may be applications that are used occasionally and need to be sized.
  • We use the powerstate flag.  SE should discuss with customer. If they feel it will be migrated but was off when the tool was run they should change flag to poweredOn.
  • Conversely changing that flag to poweredOff will tell Sizer to not size it

       Workload profiles

  • From vParition sheet in RV tools , we read two columns – Capacity MB and Consumed MB .
  • Calculate total of Capactity MB and total Consumed MB for any VM as a VM can have multiple partitions.
  • If the VM is thick provisioned, we consider Capacity MB, if thin provisioned, Consumed MB is used for calculation.
  • Then we do Groupings of VM based on CPU and RAM (example Small CPU and Small RAM).
  • Storage capacity requirement for the group (Small CPU and Small RAM) is calculated as the average of the total capacity of the VMs that are part of the group
    • Use Capacity MB for thick provisoned VM and Consumed MB for thin provisioned VM for the calculations.
  • Sizer will try to group the VMs into one of 25 workload profiles.  If the VM has simply higher capacity, CPU, RAM requirements than any of the profiles, then Sizer will flag that for user review.  The user can either assume it was over-provisioned and go with one of the profiles or create a custom workload for that larger VM.

How are the usable capacities determined for VMs?

From Vparition sheet in RV tools , we read two columns – Capacity MB and Consumed MB.

Finding capacity for Sizing: 

  • If Thin = True, then we use Consumed for Final Capacity
  • If Thin =False, then we go with Capacity for Final Capacity
  • (Note: Thin variable comes from vDisk tab)
  • We group VMs into categories such as Small CPU, Small RAM
  • We create a list of VMs for those that are Thin and those that are thick provisioned.  So we can have Small CPU and Small RAM that are thin provisioned and those that are thick provisioned.  
  • In each group in each list we then go with the max cap value of all those VMs and apply 90% HDD and 10% SSD

What are the prerequisites for running the RVTool? 

Its a windows application running on a desktop or laptop with network connectivity to the cluster that is being analyzed.  It would need vCenter userid and password to connect to the cluster.

How Sizer creates workload using RVTools data ?

 

  1. User will  import the RVtools excel into Sizer.  There is a upload file button on Import Workloads page.
  2. Sizer will pull all the info for each poweredOn VM
  3. Sizer will see if the VM fits one of the 25 profiles. It will try to fit the VM in the smallest one that still fits.
  4. Sizer will then create an excel sheet with the sizer_summary tab.  It has all the info Sizer grabbed info and state the profile that was selected or “not covered”

What does CPUs column mean in the RVTool sumary sheet ?

The values for the CPUs column in the Sizer summary sheet  indicate the CPU profile for the VM.

As explained above, every VM is classified as small, medium , large etc as per the vCPU count of the VM as below:

VCPU

  • Small = 1
  • Medium = 2
  • Large = 4
  • X-Large = 8
  • XX-Large = 16

On what basis is the VM  vCPU and vMemory classified ?

Below is the classification criteria for VM vCPU and memory

VCPU

  • Small <= 1
  • Medium <= 2
  • Large <= 4
  • X-Large <= 8
  • XX-Large <= 16

RAM

  • Small = <1.024GB
  • Medium <2.048 GB
  • Large <8.2 GB
  • X-Large <16GB
  • XX-Large <32 GB

 

What does Cores column mean in the RVTool sumary sheet ?

These indicate the total number of cores available in the host machine of the VM. These are collected in the vHost tab of the RVTool export.

What happens to the VMs which are not covered as it does not fit in one of the 25 server virtualization profiles?

Analysis has shown about 85% of the VMs fit in these 15 server virtualization profiles. For a handful of VMs that does ont fit in the profile, SEs can review the VMs with the customer. Often some VMs are over provisioned and would fit in one of the profiles.

These changes need to be made manually to the RVTool excel and imported to Sizer for a revised sizing summary.

How do I handle errors associated with importing RV tools?
Make sure you used the latest version of RVTools and that the output has not been tempered with. Also, make sure you have read/write rights on the file before uploading.

Oracle AWR support

Oracle provides Automatic workload repository (AWR) , a diagnostic tool with Oracle as a licensed feature.  This feature is available on all OS platforms. Solaris , AIX , HPUX ,Linux and Windows and will run on all the platforms.

Nutanix has a platform agnostic script (.SQL) which is used to gather information on the server running Oracle in the following format.The script will be run by an oracle DBA/admin on multiple hosts/VMs and a similar output (dbname.out) is obtained depending on the situation.  Multiple dbnameXX.out files are generated, one per database.

If we are provided a mixed output of .out files from AIX , Solaris , HPUX or Linux , we should be able to put these together into an Excel sheet and size it.

The user can then import the awr .out file or a zip file with multiple awr files (more common) into Sizer

Sizer will then do two things :

  • Process the awr file(s) and create appropriate oracle workloads per this document
  • Provide user with an excel summary file with details on the resulting workloads

AWR file structure

 AWR files do end with .out file extension but are text files. Here is a sample

This sample shows one clustered database where same database is run on multiple hosts.  

Information in an AWR we use for sizer

    • NUM_CPU_CORES_PER_NODE – this is used to determine cores in Oracle workload.
    • INSTANCES – will tell us if clustered when greater than 1
    • DB_NAME – used to name the Oracle workload
    • TOTAL_CORE_COUNT –  Not used as not always in AWR
    • HOSTS – This is needed to determine cores for the Oracle workload
    • PHYSICAL_MEMORY_GB_PER_NODE –  this will be the RAM requirement in the workload.  
    • Database_SIZE_GB –  this will be the database storage.  

How does Sizer come up with the core/ram/storage requirement for the given AWR file (or multiple files in a zip)

Each DB instance (per .out file) is a workload.  Its core/ram and capacity requirements from the awr file becomes the sizing requirements for that workload. 

However, a key point to note here is that due to  the way Oracle is licensed [for the entire cores of the host],  multiple DB instances on the same host are not treated as separate workload with separate core/ram requirements. The workload is at host level with the core and ram for the host as the core and ram requirements for the workload. The storage capacity across all DB instances on the host becomes the stoarge requirement for the workload. 

 

 

Dashboard

What are key things to know about dashboard?

 

 

The top bar allows you to

  • Create a new scenario (upper left)
  • Search for a scenario
  • Logout (upper right)

You can view My Scenarios (ones you create and thus own) or Shared Scenarios (ones shared by other users).

Shared scenarios are ones shared with you by other users

Each tile shows a summary of a sizing in terms of owner, workloads, etc.  Customer and opportunity requires SFDC login.

Search

Search for a scenario

How do you find a scenario if you got 500 of them?  In a word … Search .  However there is a panel.  There are two options

With the scenario search, just start typing and should see name of scenario

 

 

 

 

Upload BOM to SFDC

A user can upload BOM directly from Sizer to Salesforce  by clicking “Push BOM to Salesforce” button on the scenario. To create a Generate Quote from Sizer make sure that Sizing has been completed (workloads must be added to the Scenario to enable “Push BOM to Salesforce).

Required User Permissions: Salesforce Login

Steps:

  1. Go to Scenario and click on next to the scenario name.
  2. Click on “Push BOM to Salesforce” action.
  3. Enter Scenario objectives (you won’t see this step if scenario objectives have already been added).
  4. On the“Push BOM to Salesforce” modal, select opportunity name to which BOM will be pushed.
  5. Click on “Push BOM”.

Salesforce Quote

Salesforce Quotes can be generated from Sizer by clicking “Generate Salesforce Quote” button on the scenario.

Required User Permissions

  • Salesforce Login

To create a Salesforce Quote from Sizer make sure that:

  • A valid and unexpired opportunity exists in Salesforce.com
  • A valid and active Pricebook is associated with the Opportunity in Salesforce.com
  • Sizing has been completed: workloads must be added to the Scenario to enable “Generate Salesforce Quote” button.

Steps:

  1. Go to Scenario and click on next to the scenario name.
  2. Click on “Generate Salesforce Quote” action.
  3. On the “Generate Salesforce Quote” modal, an account should already be pre populated. If you linked opportunity to the scenario while creating the scenario, opportunity and pricebook (if one linked to opportunity in salesforce) should also be pre populated, otherwise please search or enter Opportunity name or ID in the Opportunity textbox. Selecting the Opportunity will populate the pricebook.
  4. Entering the opportunity will enable the “Generate” button if it wasn’t enabled.
  5. You also get the opportunity to review the Financial Assumptions section on this modal.
  6. Click on Generate.

 

Budgetary Quote

Budgetary Quotes can be generated from Sizer by clicking “Generate Budgetary Quote” button on the scenario. To create a Generate Quote from Sizer make sure that Sizing has been completed (workloads must be added to the Scenario to enable “Generate Salesforce Quote” button).

Required User Permissions: Nutanix Portal or Salesforce Login

Steps to generate a  Budgetary Quote:

  1. Go to Scenario and click on next to the scenario name.
  2. Click on “Generate Budgetary Quote” action.
  3. On the “Generate Budgetary Quote” modal, you get the opportunity to review the Financial Assumptions section on this modal.
  4. Click on Generate.

If quote generation completes successfully, you will see a notification on the page. Budgetary quote will be downloaded on your local system.