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

What Windows PerfMon Counters Should be Monitored Expand / Collapse
Author
Message
Posted Tuesday, July 6, 2010 10:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 21, 2014 9:24 AM
Points: 205, Visits: 1,352
We are using BMC Patrol. What Windows PerfMon Counters should be Monitor SQL2005 by it to ensure SQL is running ok?

...thanks
Post #948011
Posted Tuesday, February 26, 2013 12:06 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 9:37 AM
Points: 390, Visits: 1,928
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
Posted Wednesday, February 27, 2013 1:26 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 2:46 AM
Points: 215, Visits: 861
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 »

Add to briefcase

Permissions Expand / Collapse