Hello,
I'm testing client side deduplication and looking for a way to integrate reporting onto OC. The main issue now is to understand how dedupe rates are being collected. I only want a high level overview of saved space and a dedupe rate in % (manager ready).
So, the information I have is:
select * from stgpools where stgpool_name='BACKUP2'
EST_CAPACITY_MB: 20870099.4
PCT_UTILIZED: 0.1
DEDUP_SPACE_SAVED_MB: 13499
COMP_SPACE_SAVED_MB: 0
SPACE_SAVED_MB: 13499
q stg backup2 f=d
Deduplication Savings: 13,499 M (54.55%)
Compression Savings:
Total Space Saved: 13,499 M (54.55%)
To integrate that into OC, I need a valid SQL statement. So my question basically is: how on earth do they calculate the % value?
I'm testing client side deduplication and looking for a way to integrate reporting onto OC. The main issue now is to understand how dedupe rates are being collected. I only want a high level overview of saved space and a dedupe rate in % (manager ready).
So, the information I have is:
select * from stgpools where stgpool_name='BACKUP2'
EST_CAPACITY_MB: 20870099.4
PCT_UTILIZED: 0.1
DEDUP_SPACE_SAVED_MB: 13499
COMP_SPACE_SAVED_MB: 0
SPACE_SAVED_MB: 13499
q stg backup2 f=d
Deduplication Savings: 13,499 M (54.55%)
Compression Savings:
Total Space Saved: 13,499 M (54.55%)
To integrate that into OC, I need a valid SQL statement. So my question basically is: how on earth do they calculate the % value?