performance monitor lifetime

from what i've read so far, the performance monitor's data is not
instantaneous, rather collected historically since the last reboot. is
this correct? i've also read (though i can't remember where), that
there was some win2k/service pack combination that allowed for
instantaneous monitoring. i've got a feeling the monitors values are
getting skewed by past (good) performance and would like to see
instantaneous values (w/out having to reboot). thanks,
arthurThere's no one setting that control all counters. You have to read the count
er definition about how
it is measured. The ones that you are probably thinking of is Buffer Cache c
ounters that now
averages from about 2000 to 3000 last samples (changed in sp3).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"arthur" <alangham@.gmail.com> wrote in message
news:1107372326.151669.237260@.f14g2000cwb.googlegroups.com...
> from what i've read so far, the performance monitor's data is not
> instantaneous, rather collected historically since the last reboot. is
> this correct? i've also read (though i can't remember where), that
> there was some win2k/service pack combination that allowed for
> instantaneous monitoring. i've got a feeling the monitors values are
> getting skewed by past (good) performance and would like to see
> instantaneous values (w/out having to reboot). thanks,
> arthur
>|||arthur wrote:
> from what i've read so far, the performance monitor's data is not
> instantaneous, rather collected historically since the last reboot. is
> this correct? i've also read (though i can't remember where), that
> there was some win2k/service pack combination that allowed for
> instantaneous monitoring. i've got a feeling the monitors values are
> getting skewed by past (good) performance and would like to see
> instantaneous values (w/out having to reboot). thanks,
> arthur
Performance monitor values vary by counter type. You can read about them
in MSDN. If you are dealing with a counter that does not display an
instantaneous value, all you need to do is compare it to the previous
value. That's essentially what sp_monitor does (as does perfmon). That
is, it keeps track of previous values and capture date/time in order to
perform the necessary calculations. Rebooting the server won't help
because once you do, you're back to have to calculate each time.
David Gugick
Imceda Software
www.imceda.com