Get percentage free space on database volumes w/ SQL Server 2005?

Posted by Allen on Server Fault See other posts from Server Fault or by Allen
Published on 2012-12-18T16:07:50Z Indexed on 2012/12/18 17:04 UTC
Read the original article Hit count: 179

Filed under:

I am currently using SQL Server 2005 and (undocumented I believe) master..xp_fixeddrives to get free space on my database volumes as part of my monitoring.

However, this only gives me an absolute number of MB free. What I really need is percentage free.

Is there another way in SQL Server 2005 to get this? If not, is there some other light-weight way to get it? If I can, I want to avoid installing a Java JRE, or Perl, or Python on my database server. Perhaps vbscript, or a small Windows executable on the file system?

Yes, I know I can Google this, and I have. It looks like there are a few ways to accomplish it, and I'm curious how my DBA brethren have handled this.

© Server Fault or respective owner

Related posts about sql-server-2005