Re: How interpreting performance monitor counter value in Profiler

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I know it does not look like the Average is between Minimum and Maximum sometimes because it's not something static. It's dynamic and it's continually changing, this is why your calculation and its value does not match. However, after a while you'll see that it matches.

--
Ekrem Önsoy




"Pasquale" <Pasquale@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:5C371AF1-83DB-4F1B-BD60-577BDBA3848E@xxxxxxxxxxxxxxxx
Thanks for your reply.
During the analysis of performance monitor counters inside Profiler for some
of them I have noticed a selected value equals to 0 but the corresponding
minimum value is different. I think that a selected value represents the
value selected for a selected row in Profiler.
The avg value isn't the average between minimum and maximum: I have tried to
calculate it and not corresponding. I think that the avg value represents the
average in respect of the all gathered values.
Moreover I have obsersed different scales for each counter.
So, I seem it is not very simple to interpret correctly each counter's value.
Thanks

"Ekrem Önsoy" wrote:

Minimum value is the lowest value of a counter records for a resource (such
as "Available Memory" counter)
Maximum value is the highest value of a counter that records for a resource.
Average is between Minumum and Maximum.

Let me tell you with an example: Let's say you have 2000MB available memory
on your server and you started Available Memory counter in performance
monitor. This is 2000MB memory is going to be the "Maximum value" for this
counter. This value is captured when you started this counter. "Minimum
value" is recorded when this counter seizes the lowest value. This means
when your memory is used the most. For example, when you perform an
intensive running query that returns really huge result then it's gonna
consume lots of memory then your Available Memory counter's Minimum value
probably changes.

--
Ekrem Önsoy




"Pasquale" <Pasquale@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3CD09FD4-9688-446C-802C-A9BF61885DB0@xxxxxxxxxxxxxxxx
> I'm trying to monitor a SQL Server 2005.
> I have captured a trace with Profiler and a file csv with Performance
> Monitor.
> In Profiler I have opened the trace file and then imported the file > csv.
> I have noticed that for some counters the selected value is 0 but the
> minimum value is different.
> What does the minimum value for a performance monitor counter > represent?
> Is the minimum for the all corresponding counter values registered by
> Performance Monitor?
> What do avg/selected values represent?


.

Relevant Pages

  • Re: How interpreting performance monitor counter value in Profiler
    ... During the analysis of performance monitor counters inside Profiler for some ... Let me tell you with an example: Let's say you have 2000MB available memory ... In Profiler I have opened the trace file and then imported the file csv. ...
    (microsoft.public.sqlserver.tools)
  • Re: Used MSCONFIG, but still a lot of processes
    ... Among the most indicative counters would be those indicating ... The Peak Memory Usage and Virtual Memory size are not so ... I am showing the Page Faults Delta that I think is the most indicative. ... So when the performance monitor is showing thousands of pages per second, ...
    (microsoft.public.windowsxp.basics)
  • Re: ASP .NET poor performance. Memory going unused??
    ... switching between those threads (take a look at System\Context Switches/sec ... I'm using OpenSTA and the Windows ... Checking the performance monitor counters noticed the following: ... > test) and the minimum available memory is around 616Mb for all the ...
    (microsoft.public.dotnet.framework.performance)
  • ASP .NET poor performance. Memory going unused??
    ... I'm using OpenSTA and the Windows ... Checking the performance monitor counters noticed the following: ... test) and the minimum available memory is around 616Mb for all the ...
    (microsoft.public.dotnet.framework.performance)
  • Re: How interpreting performance monitor counter value in Profiler
    ... Maximum value is the highest value of a counter that records for a resource. ... Let me tell you with an example: Let's say you have 2000MB available memory on your server and you started Available Memory counter in performance monitor. ... I have captured a trace with Profiler and a file csv with Performance Monitor. ...
    (microsoft.public.sqlserver.tools)