I am seeing a high value for Procedure Removals at times but the number of
stored procedures loaded doesn't match. Is there any good documentation on
this (or advice)?

Thx
Richard Kinread

Couple of things that might be worth mentioning:

1. You could have many copies of procedures in cache. Not sure if multiple
copies of procedures in cache are counted when you say "number of sp's loaded
doesn't match". Is this from sp_sysmon output?

2. Procedure cache gets used for so many things other than procedures.
Replication affects procedure cache as well as sorting, subquery cache, update
stats, etc.


"Richard Kinread" <rkinread1 (AT) sympatico (DOT) ca> wrote

Kevin,

1) The information was taken from sp_sysmon during a busy period period.

2) Is there a way to determine what is happening with procedure cache at the
time?

Thx
"Sherlock, Kevin" <ksherlock (AT) saionline (DOT) com> wrote

Sounds like a good question for a competent MDA expert to answer (which I am
not). Hopefully, someone will jump in here with some MDA magic that can be used
to determine what the procedure cache activity is.

"Richard Kinread" <rkinread1 (AT) sympatico (DOT) ca> wrote