Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007

    Unanswered: Favorite Monitoring (Performance) Tools?

    I'm fairly new to the DBA thing.
    I've been doing quite a bit of research on monitoring MSSQL performance.

    What tools are you guys using?
    PerfMon, Dbartisan, Spotlight, or what?

    I'd like to find some free or affordable way to watch our Servers to check health/performance/etc.

  2. #2
    Join Date
    Dec 2002
    If you're using SQL 2005 (SP2), you can use a combination of SQL Health and History (aka SQL H2) and the new SQL Dashboard. Both require SQL Reporting services.

    I'm using a set of vb scripts that use WMI queries to gather basic information: storage, network config, os config, installed apps, memory and cpu utilization. These are stored in a database. You can do a google on "wmi computer inventory vb script" and I think it will come up with a variety of examples.


    Have you hugged your backup today?

  3. #3
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    "whatsup" has a lot of robust automation for wmi if you're looking for a prepackaged solution. We've had reasonable luck with it so far.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts