Buffer & Procedure cache

[Abba]

Hello,

[SQL2000]

PCProcBuffersUsedPct - Monitors the percentage of procedure buffers in the
procedure cache that are used.
PCProcCacheUsedPct - Monitors the percentage of procedure cache that is
used.

Is it safe to assume that when the above 2 counters say at 95% and above,
the SQLServer is doing fine memory-wise?

tia,
AbbA

[Uri Dimant]

Abba
I would take a look into dbcc memorystatus
Procedure Cache,Buffer Distribution sections

"Abba" <sql_...@aaa.com> wrote in message
news:u9FbJ64Y...@TK2MSFTNGP06.phx.gbl...

[TheSQLGuru]

No, it is not. There are MANY other sections of memory usage. as the other
poster noted, dbcc memorystatus (undocumented in BOL, but you can find an
article online), is the tool to use.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

"Abba" <sql_...@aaa.com> wrote in message
news:u9FbJ64Y...@TK2MSFTNGP06.phx.gbl...

[Abba]

[Abba]

Thanks Uri, Kevin.

Our Patrol admin is configuring the alarms and he wanted me to tell him the
Alarm range for those 2 counters. I have configured other sections of memory
usage, only these 2 remain.
I informed him to alarm if any of the below 2 counter goes below 95%. Is
that a good judgement?

"TheSQLGuru" <kgb...@earthlink.net> wrote in message
news:n6SdnWmpebiQtGHX...@earthlink.com...

[TheSQLGuru]

Those two memory sections are not static in size, thus you will be getting
alarms for no reason. I wouldn't (and to my knowledge none of my clients)
monitor those counters. There are much more important things to be
watching.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

"Abba" <sql_...@aaa.com> wrote in message

news:OcsTdhEZ...@TK2MSFTNGP06.phx.gbl...