How interpreting performance monitor counter value in Profiler

#1

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?

#2

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:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:3CD09FD4-9688-446C-802C-A9BF61885DB0 (AT) microsoft (DOT) com...
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?

#3

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:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:3CD09FD4-9688-446C-802C-A9BF61885DB0 (AT) microsoft (DOT) com...
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?

#4

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:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:3CD09FD4-9688-446C-802C-A9BF61885DB0 (AT) microsoft (DOT) com...
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?

#5

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:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:3CD09FD4-9688-446C-802C-A9BF61885DB0 (AT) microsoft (DOT) com...
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?

#6

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:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:3CD09FD4-9688-446C-802C-A9BF61885DB0 (AT) microsoft (DOT) com...
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?

#7

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:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:3CD09FD4-9688-446C-802C-A9BF61885DB0 (AT) microsoft (DOT) com...
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?

#8

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:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:3CD09FD4-9688-446C-802C-A9BF61885DB0 (AT) microsoft (DOT) com...
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?

#9

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:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:3CD09FD4-9688-446C-802C-A9BF61885DB0 (AT) microsoft (DOT) com...
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?

#10

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:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:3CD09FD4-9688-446C-802C-A9BF61885DB0 (AT) microsoft (DOT) com...
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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How interpreting performance monitor counter value in Profiler

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

How interpreting performance monitor counter value in Profiler - 09-25-2008 , 11:43 AM

Re: How interpreting performance monitor counter value in Profiler - 09-26-2008 , 03:24 AM

Re: How interpreting performance monitor counter value in Profiler - 09-26-2008 , 03:24 AM

Re: How interpreting performance monitor counter value in Profiler - 09-26-2008 , 03:24 AM

Re: How interpreting performance monitor counter value in Profiler - 09-26-2008 , 03:24 AM

Re: How interpreting performance monitor counter value in Profiler - 09-26-2008 , 03:24 AM

Re: How interpreting performance monitor counter value in Profiler - 09-26-2008 , 03:24 AM

Re: How interpreting performance monitor counter value in Profiler - 09-26-2008 , 03:24 AM

Re: How interpreting performance monitor counter value in Profiler - 09-26-2008 , 03:24 AM

Re: How interpreting performance monitor counter value in Profiler - 09-26-2008 , 03:24 AM