Re: [ADSM-L] Select statement for deduplication & compression statistics ...
2017-12-11 04:32:02
Hi
This is simple math....
select
stgpool_name,DEDUP_SPACE_SAVED_MB/(DEDUP_SPACE_SAVED_MB+COMP_SPACE_SAVED_MB+(EST_CAPACITY_MB*PCT_UTILIZED/100))*100||'%'
as "Dedup savings" from stgpools
select
stgpool_name,COMP_SPACE_SAVED_MB/(COMP_SPACE_SAVED_MB+(EST_CAPACITY_MB*PCT_UTILIZED/100))*100||'%'
as "Compression savings" from stgpools
Best Regards
Anders Räntilä
|
ADSM.ORG Privacy and Data Security by KimLaw, PLLC
|