PerfMon Counters Values

  • I have done perfmon analysis for CPU, DiskIO, Memory and processor counters.

    I am looking for some document where I can compare above counters value to do performance analysis.

    Can anybody point me to document for comparision?

    p.s. I have come across many documents but could not fine one for value comparision.

  • You just check with your benchmark (accepted) values. Ideally it is based on the concurrency, Database sizes and h/w efficiency.

  • There isn't a "right" number for a lot of these values. It really depends on the system you're on. Simply collecting one set of values is usually not enough. We generally try to collect a set of values from a very low traffic position on the system and a set from a high traffic position. Then, when you collect a third set of values, you have something to compare them to.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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