SQL Server Counters

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQL Server Counters

SQL Server Counters

Rate Topic

Display Mode

Topic Options

Author

Message

Jeetendra

Posted Thursday, March 25, 2010 12:50 AM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, May 06, 2013 4:55 AM
Points: 612, Visits: 437

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

karthik -450760

Posted Thursday, March 25, 2010 1:01 AM

SSC 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

Robbert Hof

Posted Thursday, March 25, 2010 5:51 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:01 PM
Points: 1,282, Visits: 743

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 »

Permissions