Disk Space Information for SQL Servers

Question

Disk Space Information for SQL Servers

klecknerl

SSC Enthusiast

Points: 100
More actions
May 8, 2012 at 9:37 am

#273739

I am familiar with the ways I can keep track of how much space is free on my disk drives but what I would really like to be able to see is the total size of the drive. What is the best way to get this information across multiple servers. My goal is to setup a process to keep track of the disk usage over time.
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Thomas Stringer SSCarpal Tunnel Points: 4038 More actions · Answer 1

You can use PowerShell to handle this. But if you are set on using it through SQL Server, then execute xp_fixeddrives across all of your servers and store that accordingly.

Twitter: @SQLife
Email: sqlsalt(at)outlook(dot)com

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 2

PowerShell + WMI works well for this type of work.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

Thomas Stringer (5/8/2012)
You can use PowerShell to handle this. But if you are set on using it through SQL Server, then execute xp_fixeddrives across all of your servers and store that accordingly.

+1 for Powershell, 0 or -1 for xp_fixeddrives, depending on whether mountpoints are EVER used.

opc.three (5/8/2012)
PowerShell + WMI works well for this type of work.

+1

Or SSIS + WMI

CEWII