Post reply

What Windows PerfMon Counters Should be Monitored

  • July 6, 2010 at 10:13 am

    #141019

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

    ...thanks

  • February 26, 2013 at 12:06 pm

    #1591286

    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.

  • February 27, 2013 at 1:26 am

    #1591433

    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'

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

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