ONTAP DF command does not report used size correctly for volumes with Windows sparse files
Applies to
- ONTAP 9
- Space accounting
- Windows sparse files
Issue
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%