ADSM-L

Re: [ADSM-L] Select statement for deduplication & compression statistics ...

2017-12-11 04:32:02
Subject: Re: [ADSM-L] Select statement for deduplication & compression statistics ...
From: Anders Räntilä <Anders AT RANTILA DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 11 Dec 2017 09:29:54 +0000
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ä

<Prev in Thread] Current Thread [Next in Thread>

ADSM.ORG Privacy and Data Security by KimLaw, PLLC