Skip to main content
NetApp Knowledge Base

ONTAP DF command does not report used size correctly for volumes with Windows sparse files

Last Updated:

Applies to

  • ONTAP 9
  • Space accounting
  • Windows sparse files


A volume hosting a sparse file, like a Microsoft SQL database, reports its physical used size correctly with volume show-space and volume show-footprint but not with df command.
  • volume show-footprint output:

Volume : VOl1_HyV_SQL

Feature                                           Used      Used%
--------------------------------      ----------------      -----
Volume Data Footprint                           4.25TB         7%
Flexible Volume Metadata                        27.0GB         0%
Delayed Frees                                    359GB         1%

Total                                           4.63TB         8%
  • volume show-space output :

Volume : VOl1_HyV_SQL

Feature                                           Used      Used%
--------------------------------      ----------------      -----
User Data                                       56.5TB        94%
Filesystem Metadata                             4.01GB         0%
Inodes                                          6.84MB         0%
Deduplication                                   4.00KB         0%
Quota Metafiles                                 20.0KB         0%
Total                                       >>> 56.6TB <<<    94%
Total Physical Used                             4.25TB         7%
Logical Used                                    61.9TB       103%
Logical Available                               3.39TB         6%
  • df -h output:
Filesystem                     Total Size  used     avail   capacity
/vol/VOl1_HyV_SQL/   60.00t      56.61t   3.39t   94%

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.