Basically 1.5 Space has been reserved by SQL Server and OS sees it as 1.5 GB full.

See below how it looks from SSMS and from My Computer. You can enable this option by hitting F6 or enabling from Options Menu as shown below.īefore proceeding any further, I’ve a empty database named “space” which is 1.5 GB in size. Let’s explore the “Show FreeSpace Option” by looking at my SQL Data drive.

Once the Scanning is complete, It gives a colorful report which is actually interactive(you can directly go to a file/folder just by clicking on a block whichever appears to be largest in the image). I’ve chosen “C:” for illustration purposes. Let’s see how it works….As soon as you double Click on the executable, you’lll be welcomed with below Screen.Īs you can see, it gives us options to Scan all Drives, Individual Drives or even at folder level. I’ve Installed this on one of my Test Servers. Let’s see WinDirStat First, Let me tell you this, It’s a free tool from Sourceforge, which is aweesome 🙂 you can Just Bing it or google it or visit for more info. WinDirStat ( Win dows Dir ectory Stat istics ) This is one ugly situation to be in, especially if that’s the very first time you logged onto that box during your On Call Shift and You’ve no idea what files are sitting there on Drives! So, what are the tools which helped me in gathering this info in just few minutes or even seconds, with just few Mouse Clicks?ġ. I Bet, almost all of us might have been in a “Drive running Out of space” situation at least once in our career. Hey Folks! Let me introduce you to couple of my personal favorite tools for quickly understanding the space distribution on your Hard Drives on your Windows Servers.

Windirstat