Hello:

The installation details:

W2K SP4, SQL Server 2000 Ent with 1GB RAM. It is a Bi-P3.

When I run the Profiler to trace Stored Procedure performance, I get a
bunch of SP:CacheMiss for couple of stored procedure I invoke quite
often in a web app.
But I do not see SP:Recompile.

Here are my questions:

i) If the plan is not in the Cache, why am I not see SP: Recompile.
Where else can it be tugged.
ii) What are the other counters I need to monitor to see if I need more
memory.

Thanks in advance for any leads on this.

Regards: