T
Travis-WP
Guest
I have a Windows Server 2008 R2 virtual machine running MS SQL 2005 on top of a VMWare ESXi 5.5 host on a SAN datastore.
Consistently it has been "losing" 2GB of hard disk space per day and I can't figure out why. It only appears to occur some time in the evening. In the morning around 9 AM I checked and it was at 34.6 GB. In the evening, after 5 PM, it had lowered to 32.5 GB of free space.
There are no snapshots on the VM. RAM is consistently at around 8 GB with +/- 200 MB fluctuations. Page file is consistent at 16 GB. Does not occur over a weekend. On Friday it will be say 30.1 GB of free space. Monday morning it will be 30 GB of free space then by Monday evening it's at 28.3 GB.
Daily backups do occur for the SQL database onto the C: drive but are overwritten and occur at 2:15 AM. TLOGS are of very small size and do not change very much.
I followed the tips here: http://blogs.msdn.com/b/ntdebugging/archive/2008/07/03/ntfs-misreports-free-space.aspx
No alternate data streams. Shadow copy is taking up 0 space. Size on disk vs. size shows a 200 MB difference. Chkdsk does show 2 GB more than what My Computer shows for free space so I am going to start keeping track of that, but in the big picture the difference seems irrelevant because I can see a 20 GB difference over the course of a week.
Here is a screenshot taken from WinDirstat. As you can see the total space only increases by 1 GB yet from the start time until the end time the free space has gone from 42.1G to 25.6G. I have looked at the "Unknown" space that WinDirStat reports and it the unknown files did have a 1 GB increase.
Continue reading...
Consistently it has been "losing" 2GB of hard disk space per day and I can't figure out why. It only appears to occur some time in the evening. In the morning around 9 AM I checked and it was at 34.6 GB. In the evening, after 5 PM, it had lowered to 32.5 GB of free space.
There are no snapshots on the VM. RAM is consistently at around 8 GB with +/- 200 MB fluctuations. Page file is consistent at 16 GB. Does not occur over a weekend. On Friday it will be say 30.1 GB of free space. Monday morning it will be 30 GB of free space then by Monday evening it's at 28.3 GB.
Daily backups do occur for the SQL database onto the C: drive but are overwritten and occur at 2:15 AM. TLOGS are of very small size and do not change very much.
I followed the tips here: http://blogs.msdn.com/b/ntdebugging/archive/2008/07/03/ntfs-misreports-free-space.aspx
No alternate data streams. Shadow copy is taking up 0 space. Size on disk vs. size shows a 200 MB difference. Chkdsk does show 2 GB more than what My Computer shows for free space so I am going to start keeping track of that, but in the big picture the difference seems irrelevant because I can see a 20 GB difference over the course of a week.
Here is a screenshot taken from WinDirstat. As you can see the total space only increases by 1 GB yet from the start time until the end time the free space has gone from 42.1G to 25.6G. I have looked at the "Unknown" space that WinDirStat reports and it the unknown files did have a 1 GB increase.
Continue reading...