question

zillabaug avatar image
zillabaug asked

unexplained space consumption of a data drive on my Virtual machine

The data drive on my VM appears full but the actual space consumed is only 84GB OUT OF 200GB. Has anyone encountered something like this before? When I first saw this, the first thing i did was to check the size of the transaction logs to make sure that I don't have transaction log inflation. the log file size is fine.Does anyone have a clue or point me in the right direction to fix this? Please refer to the screenshots attached for clarification. Thanks![alt text][1] [1]: /storage/temp/3751-2space.jpg
sql server 2012transaction-logwindows-server-2012hardwarevmware
1space.jpg (56.0 KiB)
2space.jpg (31.4 KiB)
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Nothing VM specific comes right to mind. hidden files? recycle bin? You might try a disk space analyzer to see if it catches something you missed - https://duckduckgo.com/?q=disk+space+analyzer
2 Likes 2 ·
Might have already been done, you could also use SSMS and look to see if you have a data/log file that might be consuming the space? Something like: SELECT database_id,name,size FROM sys.master_files WHERE physical_name LIKE '%D:\%' ORDER BY size DESC If it's even SQL Server related.
1 Like 1 ·
Check to see if the server is storing the page file on the drive. I've had a server with limited space on the C: drive move the page file to a different drive when the memory on the server was increased to more than what was available on the C: drive. It will be a hidden file in the root of the drive called pagefile.sys
1 Like 1 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.