What Windows PerfMon Counters Should be Monitored

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » What Windows PerfMon Counters Should be...

What Windows PerfMon Counters Should be Monitored

Rate Topic

Display Mode

Topic Options

Author

Message

rew-370421

Posted Tuesday, July 06, 2010 10:13 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 06, 2013 8:31 AM
Points: 205, Visits: 1,329

We are using BMC Patrol. What Windows PerfMon Counters should be Monitor SQL2005 by it to ensure SQL is running ok?

...thanks

Post #948011

muthyala_51

Posted Tuesday, February 26, 2013 12:06 PM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:30 PM
Points: 229, Visits: 1,065

Hi,

I am also looking for the same, did you get the list of monitoring parameters you are going to be monitored and the thresholds- if you have any can you please share? Thanks.

Post #1424208

david.alcock

Posted Wednesday, February 27, 2013 1:26 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 03, 2013 2:25 AM
Points: 115, Visits: 450

I use these (from brentozar.com) and then add others if and when the need arises.

•Memory – Available MBytes
•Paging File – % Usage
•Physical Disk – Avg. Disk sec/Read
•Physical Disk – Avg. Disk sec/Write
•Physical Disk – Disk Reads/sec
•Physical Disk – Disk Writes/sec
•Processor – % Processor Time
•SQLServer: Buffer Manager – Page life expectancy
•SQLServer: General Statistics – User Connections
•SQLServer: Memory Manager – Memory Grants Pending
•SQLServer: SQL Statistics – Batch Requests/sec
•SQLServer: SQL Statistics – Compilations/sec
•SQLServer: SQL Statistics – Recompilations/sec
•System – Processor Queue Length

'Only he who wanders finds new paths'

Post #1424388

« Prev Topic | Next Topic »

Permissions