OnCommand Insight DWH Database Question

[cedar dew]

I was using DWH_Inventory.totalUsedCapacityMB field in a report. The description reports: " Capacity consumed by internal-volume from storage pool". In any case. One of my colleagues is saying that the Used Capacity is reflected deduplication savings. I do not think this is correct though. I think it simply Used Capacity. Does anyone know for sure?

[limber ingot]

Hey @cedar dew, in dwh_inventory the totalUsedCapacityMB is what is actually consumed on the storage pool after deduplication and compression savings - not the 'logical space used' before those benefits - consider this the view for 'what is this internal volume carving from my storage pool'. If you want overall more granularity on the internal_volume I'd recommend to look at dwh_capacity.internal_volume for example - here you will see both usedCapacityMB (Total used capacity on this internal volume.) which is the logical view of what is consumed on the volume and consumedCapacityMB (Capacity consumed by this internal volume from storage pool.) which reflects what the volume actually is taking away from the storage pool's available capacity.

[cedar dew]

Thanks Miles, good stuff!