topic Re: Monitoring Storage Data Efficiency in Microsoft Virtualization Discussions

Monitoring Storage Data Efficiency

1VINAYKUMAR — Wed, 04 Jun 2025 22:05:29 GMT

Hi Guys,

I need to Monitor the Storage Data Efficiency using the powershell scripts on NetApp Clusters 8.3. can anybody assist me with a powershell scripts for the data efficiency monitoring mostly on the Netapp Volumes.

regards

Re: Monitoring Storage Data Efficiency

asulliva — Fri, 12 Feb 2016 22:12:42 GMT

Have you tried the "Get-NcEfficiency" cmdlet? Here is some example output:

   Vserver: Infrastructure

Name                       Capacity       Used   SnapshotUsed    Returns  EffectiveUsed  EfficiencyPercent
----                       --------       ----   ------------    -------  -------------  -----------------
software                     1.0 TB   393.6 GB       147.7 MB   531.1 GB       924.7 GB              90.3%
vice_infrastructure          2.0 TB   656.3 GB       121.2 GB   800.0 GB         1.4 TB              71.1%
VICE_Infrastructure_root    19.0 MB   152.0 KB       716.0 KB    80.4 KB       232.4 KB               1.2%

Andrew

Re: Monitoring Storage Data Efficiency

1VINAYKUMAR — Tue, 16 Feb 2016 11:24:07 GMT

Hi Asulliva,

My requirement is that, I need a powershell script which shows output as comes in the below link.

https://library.netapp.com/ecmdocs/ECMP1196906/html/GUID-307CD98D-AE25-4B5D-90CD-8100F86543F8.html

Space Saved by Storage Efficiency, Space Saved by Deduplication, Space Saved by Commpression.

Thanks & regards

Re: Monitoring Storage Data Efficiency

asulliva — Tue, 16 Feb 2016 14:33:23 GMT

All the data is in the objects returned by "Get-NcEfficiency", will just need to format it. Here is a quick version:

Get-NcEfficiency | Select Vserver,Name,
    @{ N="Space Saved by Storage Efficiency"; E={ ConvertTo-FormattedNumber $_.Returns.Total -Type DataSize -NumberFormatString "0.0" }},
    @{ N="Percentage Saved by Storage Efficiency"; E={ [Math]::Round($_.EfficiencyPercent) }},
    @{ N="Space Saved by Deduplication"; E={ ConvertTo-FormattedNumber $_.Returns.Dedupe -Type DataSize -NumberFormatString "0.0" }},
    @{ N="Percentage Saved by Deduplication"; E={ [Math]::Round(($_.Returns.Dedupe / $_.EffectiveUsed) * 100) }},
    @{ N="Space Saved by Compression"; E={ ConvertTo-FormattedNumber $_.Returns.Compression -Type DataSize -NumberFormatString "0.0" }},
    @{ N="Percentage Space Saved by Compression"; E={ [Math]::Round(($_.Returns.Compression / $_.EffectiveUsed) * 100) }}

Andrew

Re: Monitoring Storage Data Efficiency

1VINAYKUMAR — Wed, 17 Feb 2016 09:35:32 GMT

Hi Asulliva,

I need the same as i requested but when i compare the same with NetApp CLI and with Powershell both gives two different output when used the same values. if you look below the "Percentage Saved by Storage Efficiency" show as 208% whereas the "sis-space-saved-percent" shows 21%. similarly other percentage fields.

seems somthing is missing in the powershell query. though i am not good in scripting. can you please look into it.

ASPST00086::> vol show -vserver ASPST00094 -volume ASPST00093_G -fields vserver,volume,size,sis-space-saved,sis-space-saved-percent,dedupe-space-saved,dedupe-space-saved-percent,compression-space-saved,compression-space-saved-percent
vserver volume size sis-space-saved sis-space-saved-percent dedupe-space-saved dedupe-space-saved-percent compression-space-saved compression-space-saved-percent
------------- ------------------ ----- --------------- ----------------------- ------------------ -------------------------- ----------------------- -------------------------------
ASPST00094 ASPST00093_G 720GB 177.4GB 21% 111.5GB 13% 65.93GB 8%

ASPST00086::>

Powershell script

PS P:\> Get-NcEfficiency -vserver ASPST00094 -volume ASPST00093_G | Select Vserver,Name,@{N="Capacity"; E={[math]::Round($_.capacity/1GB,2)}}, @{ N="Space Saved by Storage Efficiency"; E={ ConvertTo-FormattedNumber $_.Returns.total -Type DataSize -NumberFormatString "0.0" }}, @{ N="Percentage Saved by Storage Efficiency"; E={ [Math]::Round($_.EfficiencyPercent) }}, @{ N="Space Saved by Deduplication"; E={ ConvertTo-FormattedNumber $_.Returns.Dedupe -Type DataSize -NumberFormatString "0.0" }}, @{ N="Percentage Saved by Deduplication"; E={ [Math]::Round(($_.Returns.Dedupe / $_.EffectiveUsed) * 100) }}, @{ N="Space Saved by Compression"; E={ ConvertTo-FormattedNumber $_.Returns.Compression -Type DataSize -NumberFormatString "0.0" }}, @{ N="Percentage Space Saved by Compression"; E={ [Math]::Round(($_.Returns.Compression / $_.EffectiveUsed) * 100) }}|ft -AutoSize

Vserver       Name               Capacity Space Saved by Storage Efficiency Percentage Saved by Storage Efficiency Space Saved by Deduplication Percentage Saved by Deduplication Space Saved by Compression         Percentage Space Saved by
                                                                                                                                                                                                                                    Compression
-------       ----               -------- --------------------------------- -------------------------------------- ---------------------------- --------------------------------- -------------------------- ----------------------------------
ASPST00094 ASPST00093_G      720 GB          814.8 GB                                                             208 111.5 GB                                                     7 65.9 GB                                                     4

PS P:\>

Re: Monitoring Storage Data Efficiency

asulliva — Wed, 17 Feb 2016 15:28:41 GMT

I think this is because the cmdlet's total space saved value counts snapshots and clones as a part of the storage efficiency number. Let's try removing those...

Get-NcEfficiency -Volume software | Select Vserver,Name,
    @{ 
        N="Space Saved by Storage Efficiency"; 
        E={ 
            ConvertTo-FormattedNumber ($_.Returns.Dedupe + $_.Returns.Compression) -Type DataSize -NumberFormatString "0.0" 
        }
    },
    @{ 
        N="Percentage Saved by Storage Efficiency"; 
        E={ 
            [Math]::Round((($_.Returns.Dedupe + $_.Returns.Compression) / ($_.Used + $_.Returns.Dedupe + $_.Returns.Compression)) * 100) 
        }
    },
    @{ N="Space Saved by Deduplication"; E={ ConvertTo-FormattedNumber $_.Returns.Dedupe -Type DataSize -NumberFormatString "0.0" }},
    @{ N="Percentage Saved by Deduplication"; E={ [Math]::Round(($_.Returns.Dedupe / ($_.Used + $_.Returns.Dedupe + $_.Returns.Compression)) * 100) }},
    @{ N="Space Saved by Compression"; E={ ConvertTo-FormattedNumber $_.Returns.Compression -Type DataSize -NumberFormatString "0.0" }},
    @{ N="Percentage Space Saved by Compression"; E={ [Math]::Round(($_.Returns.Compression / ($_.Used + $_.Returns.Dedupe + $_.Returns.Compression)) * 100) }}

This way we aren't using the "Total Return" (which is based off of snapshots + clones + dedupe + compression) or the "Effective Used" (actual used + total returns), instead just taking into account dedupe and compression.

Andrew

Re: Monitoring Storage Data Efficiency

Kirand1979 — Wed, 26 Oct 2016 06:35:05 GMT

any good place i can definition of each of these ? say, Percentage Saved by Storage Efficiency