SQL Server Counters

  • 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

  • Hi,

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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply