SQL Server Performance

Performance Counters Collection on DB

Discussion in 'Performance Tuning for DBAs' started by Andrea, Feb 17, 2003.

  1. Andrea New Member

    PERFMON is only capable to redirect collected data on a file (csv or binary format) and I need to have that data on a DB table (MS SQL Server). It's not easy to organize a daily collector process (mybe a DTS) that get all data from all these files named "name.yyyymmdd".
    It would be much better to send the data to the db table real time, as soon as it is detected.
    Is it possible to find an example of WMI application (or something else) to build an agent?
    Thank you all
    Andrea
  2. bradmcgehee New Member

    There are some third-party programs that can do this, such as those fromhttp://www.tntsoftware.com, but I am not familiar with any WMI or other applications that do this that are available for free, although this is a great idea. Anyone up to writing such an aplication?

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com

Share This Page