Import Performance Monitor Data into a table.

• Kev

  Default port

  Points: 1435

  More actions

  July 12, 2004 at 8:11 pm

  #60407

  Hi all,

   

  I am trying to import performance monitor data into a SQL table in the format

  Date Time             Server Name               Counter

   

  This task needs to be automatic, as I do not whish to revisit the import every day

   

  Does anyone who of a way to achieve this?

  Thanks

  Kevin

• Kev

  Default port

  Points: 1435

  More actions

  July 13, 2004 at 2:31 pm

  #514461

  Hi ,

  Found a solution. Use windows xp or 2003 and performance monitor will write directly via ODBC to SQL Server

   

  Cool Thanks Bill !

  Kevin