Performance Monitor Counters

  • Hi everyone!

    I have this explanation for the counter % IDLE TIME from Steve Choy :

    % IDLE TIME = This measures the percentage of time the disk was idle during the sample interval. If this counter falls below 20 percent, the disk system is saturated. You may consider replacing the current disk system with a faster disk system.

    So, I want to know if the average falls below 20% or if at any time during the monitoring of the server.

    Also, I want to know if the server disks setup which is a RAID 1 array of disks, partitioned so I have 2 logical disks, C: and D: but one physical disk is going to affect the accuracy of the counter.

    Thanks for any help!

    FJM

  • fjmorales (5/14/2009)


    Hi everyone!

    I have this explanation for the counter % IDLE TIME from Steve Choy :

    % IDLE TIME = This measures the percentage of time the disk was idle during the sample interval. If this counter falls below 20 percent, the disk system is saturated. You may consider replacing the current disk system with a faster disk system.

    So, I want to know if the average falls below 20% or if at any time during the monitoring of the server.

    Average.

    Also, I want to know if the server disks setup which is a RAID 1 array of disks, partitioned so I have 2 logical disks, C: and D: but one physical disk is going to affect the accuracy of the counter.

    The disk configuration will not affect the accuracy of the %IDLE Counter (this is not true of many of the disk counters). However, it WILL affect the accuracy of the rule of thumb that Mr. Choy gave you. Saturation thresholds go down with each additional physical data disk added to a volume/logical disk (but go up for parity disks).

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • Thanks!

    Now I have another question. This one is probably considered by many obvious but the truth is that I’m not sure and my work depends on it so if many other has the doubt well I’m going to take it for the team.

    Those the counters Processor(*)\% Processor Time, Processor(*)\% User Time, Processor(*)\% Interrupt Time come with the % already calculated (99.5 = 99.5%) or the info is on decimals? (.1525 = 15.25%)

    Thanks again for any help that you can give!

    FJM

  • fjmorales (5/15/2009)


    Those the counters Processor(*)\% Processor Time, Processor(*)\% User Time, Processor(*)\% Interrupt Time come with the % already calculated (99.5 = 99.5%) or the info is on decimals? (.1525 = 15.25%)

    If you are getting it out of PerfMon then it will be like "99.55". But, IIRC, if you are calling the performance counters yourself, then they will be like "0.9955". (Hmm, not sure if I am remembering this last part correctly, its been a few years...)

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • I’m using perfmon and I’m analyzing the info on excel .

  • fjmorales (5/15/2009)


    I’m using perfmon and I’m analyzing the info on excel .

    Then yes, in the CSVs the "%" counters come out as "99.99".

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 6 posts - 1 through 5 (of 5 total)

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