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