Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Posts
    21

    Unanswered: Getting CPU and I/O usage for several Servers

    Hello ,

    I would like a script for MSSQL 2000 for collection of utilization data for cpu and ram. I need to have the data from several servers.

    This data for all servers should be stored in a database. I am looking for 10 minute increments.

    How can I go about this.

    Thanks

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Personally I would write this as an NT service using perfmon counters. I don't think it is necessarily approriate for this to live inside SQL Server itself, particularly if SQL Servers performance is an issue.
    oh yeah... documentation... I have heard of that.

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

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    I use a VBScript and WMI Counters. The Script is run from a single server with network access to the monitored server(s). The data is collected every fifteen minutes (can be more or less frequent) as the program is scheduled through a Windows scheduled task.

    There's lots of info out there on WMI counters and scripting. My own script is a collection of scraps posted by other people and synthesized into a coherent program through kludgy hacking on my own.

    A Windows service would be better. A web server to which servers could post would probably be best of all.

    PM me if you want the code; but I warn you -- I'm a DBA by trade, not a developer.

    Regards,

    hmscott
    Have you hugged your backup today?

  4. #4
    Join Date
    Sep 2006
    Posts
    21
    It would be great if you can send me your script , so that I can modify according to my requirements.


    Frankly I am new to DBA stuff and breaking my head over it..

    Thanks in advance

    vaddi

Posting Permissions

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