HOWTO--Performance Counters to SQL Databases

• csoloway

  Ten Centuries

  Points: 1087

  More actions

  February 28, 2007 at 1:08 pm

  #176197

  I am trying to set up 12 servers to write to different tables in a PERFMON database.  Is there a way to do this?  I set up one as a model and it creates 3 tables named: 

  dbo.CounterData

  dbo.CounterDetails

  dbo.DisplaytoID

   

  I would like to record the data to 1 table by server name.  Can anyone point me to howto documentation on how to do this?

• MohammedU

  SSCoach

  Points: 19644

  More actions

  February 28, 2007 at 5:36 pm

  #692471

  You don't need to create one table for each server...

  One of these three tables will have machine name in it...I believe you have to filter based on machine name when you query the data...

  Read the following article...

  10 Baselining Tips for SQL Server: Lessons From the Field

  http://www.sql-server-performance.com/gv_baselining_tips.asp

   

  MohammedU
  Microsoft SQL Server MVP