Post reply

Need recommendation on SQL 2k, 2k5 Disk Monitoring tool

  • June 13, 2008 at 6:00 am

    #192422

    ISO a SQL Server 2000/2005 disk monitoring tool which will render disk space info by SQL Server instance and drive letter. Example:

    SQL Server 1

    Disk Allocated Used

    C: 20 GB 12 GB

    D: 50 GB 35 GB

    E: 100 GB 92 GB

    Any recommendation on "best of breed" tools is appreciated. thx in advance

    BT

  • June 13, 2008 at 7:05 am

    #828450

    I run this SP:

    EXEC xp_fixeddrives

    along with a bunch of other queries (error logs, failed agent jobs, db file usage, etc) against all primary sql servers on a scheduled agent job and dump the results to tables. Then read the table with disk space < 1024MB and e-mail results.

    Those monitoring tools were hard to justify costs based on business requirements, so I built something myself.

Viewing 2 posts - 1 through 2 (of 2 total)

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