NetApp Cloud Insights MU Count Requirements from NetApp OnCommand Insight DWH

on

The following OCI DWH MySQL queries are a quick way to get your anticipated CI MU count (assuming pretty much everything you have in OCI is going to be ported across to CI.)

I am using this link - Subscribing to Cloud Insights (netapp.com) - which details:

  • 1 MU = 2 hosts (any virtual or physical machine)
  • 1 MU = 4 TiB of unformatted capacity of physical or virtual disks

Note: For these data collectors 1MU = 40TiB:

  • Dell EMC ECS
  • Hitachi Content Platform
  • IBM Cleversafe
  • NetApp StorageGrid

1) Storage MUs

SELECT SUM(MUs) FROM(
SELECT
CASE
WHEN family IN ("ECS","StorageGRID") THEN rawCapacityMB/43980465
ELSE rawCapacityMB/4398046
END AS 'MUs'
FROM dwh_inventory.storage
) AS t0

Note: If you have Hitachi Content Platform and/or IBM Cleversafe, add them to the family IN above.

2) VM MUs

SELECT
count(*)/2 AS 'MUs'
FROM dwh_inventory.hv_virtual_machine AS vm

3) ESXi MUs

SELECT
count(*)/2 AS 'MUs'
FROM dwh_inventory.hv_server

Very easy.

Note: Bare-metal hosts don't cost anything (i.e. hosts discovered from SAN Fabric zoning.)

Comments

Post a Comment