Post reply

Disk Space Information for SQL Servers

  • 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

  • May 8, 2012 at 10:06 am

    #1484637

    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

  • May 8, 2012 at 3:06 pm

    #1484789

    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

  • May 8, 2012 at 3:32 pm

    #1484796

    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

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

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