Drive Space Monitoring Gets An Update

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 717413

    I have attached the script to the article.

    My apologies.

  • Paul MacDonald-321642

    SSC Enthusiast

    Points: 165

    Thanks.....

    Paul M.

  • shaun.stuart

    SSCertifiable

    Points: 6711

    The script is linked to in a zipfile at the bottom of the article. It's under the "Resources" heading and it's called DiskSpaceStats.zip.

    FYI, I wrote a part 2 to this article on my blog at http://shaunjstuart.com/archive/2010/10/im-published/[/url] which details how I used the data this collects to make a SSRS report.

    Shaun

  • bwolf

    Newbie

    Points: 7

    Very cool. Not seeing the attached script either.

  • davids-1023752

    Valued Member

    Points: 65

    Thanks

  • Mat Raftree

    Grasshopper

    Points: 10

    We had to roll our own solution since we are using windows mountpoints for mapping new SAN luns into our clusters. Any chance you will be adressing that issue?

  • shaun.stuart

    SSCertifiable

    Points: 6711

    Probably not, since I don't have a setup like that that I can test with. Sorry!

  • CJ_Cerro

    Valued Member

    Points: 72

    Mat Raftree (10/4/2010)


    We had to roll our own solution since we are using windows mountpoints for mapping new SAN luns into our clusters. Any chance you will be adressing that issue?

    It can be done in Powershell using the "win32_mountpoint" class... I've been experimenting with it myself as I have the exact same problem. 🙂

  • SQLRNNR

    SSC Guru

    Points: 281243

    Thanks for the article.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • mcvilbar

    Say Hey Kid

    Points: 701

    Though, I did not test it yet on my environment right now but I'm very thankful and very grateful to Shaun for having this kind of article... Thanks a lot Shaun!!!! 🙂

  • shaun.stuart

    SSCertifiable

    Points: 6711

    Glad to help!

  • AmcAmx

    SSC Veteran

    Points: 209

    Still can't get the files. Anyone else have any luck ?

    Oops ! my bad... I have it working now...

    ThanX for the great script

    AmcAmx

  • Dominic-230373

    Newbie

    Points: 8

    It works fine for usual drives with a drive-letter

    As soon as a disk has been mounted as a subfolder in a existing drive and the databases are within the mounted drive....it doesn't work.

    Regards,

    Dominic

  • Dominic-230373

    Newbie

    Points: 8

    DAMM!!!....sorry guys....I saw now the similar posts :-S

  • d trotman

    Valued Member

    Points: 58

    Great article and scripts. I'm in the process of trying them out now. Just a small issue. Please remember the square brackets [] in your dynamic SQL either side of the servername. That way server instances will get taken care of also.

Viewing 15 posts - 16 through 30 (of 65 total)

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