SQL Server Counters

• Jeetendra

  SSCrazy

  Points: 2076

  More actions

  March 25, 2010 at 12:50 am

  #138028

  Hi All,

  I want to add some of the Counters in the perfmon to get the Performance of the SQL Server as well as the OS.

  There is a option of adding from the files as well as physically adding one-one counter.

  I need help on the file format which needs to be given to the Perfmon as i need to monitor the same counters for around 300+ Servers.

  Please do let me know.

  ---

  Kindest Regards,

  Jeetendra
  

• karthik -450760

  Ten Centuries

  Points: 1362

  More actions

  March 25, 2010 at 1:01 am

  #1139423

  Hi,

  I prefer saving the values of the counters in csv format...

• Robbert Hof

  SSCrazy

  Points: 2778

  More actions

  March 25, 2010 at 5:51 am

  #1139522

  Hi Jeetendra,

  In Programs/Administrative Tools/Performance create a new Counter Log.

  After that, save this with "Save Settings as". Now you got a HTM file.

  You can edit this one in notepad (when you want to monitor other Named Instances you have to do this)

  Copy this file to the other servers and open Performance on these servers.

  Import the file using "New Log Settings From".

  HTH

  Robbert