Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Counters Expand / Collapse
Author
Message
Posted Thursday, March 25, 2010 12:50 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, February 05, 2014 11:20 PM
Points: 612, Visits: 452
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

Post #889561
Posted Thursday, March 25, 2010 1:01 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 31, 2010 1:05 PM
Points: 44, Visits: 245
Hi,

I prefer saving the values of the counters in csv format...
Post #889567
Posted Thursday, March 25, 2010 5:51 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, March 24, 2014 2:31 AM
Points: 1,287, Visits: 776
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



Post #889689
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse