add memory?

Hi,
I'm checking my performance of sql 2000 ent. on a w2k adv. server. There
are 2gb's of memory available. the server is dedicated for sql server
(at least i think it is).
I've noticed that the counter sql server: cache manager - cache hit
ratio is on average 67-70. The counter sql server:buffer manager -
buffer cache hit ratio is always above 99%. SQL Server uses dynamic mem
alloc.
All other import counters like processor and physical disk shows low values.
Could there be a memory bottleneck where the asigned cache for sql is
too low?You donâ't have a memory issue.
From SQL Server Books Online (BOL):
â'SQL Server: Cache Manager Object
The Cache Manager object provides counters to monitor how Microsoft® SQL
Serverâ?¢ uses memory to store objects such as stored procedures, ad hoc and
prepared Transact-SQL statements, and triggers.â'
Any SP, Trigger or Transact-SQL statements which are being called for the
1st time will not have an Execution Plan kept in the Cache. Besides, there
are many scenarios when SQL Server decides to generate a fresh Execution
Plan.
Have a look at the â'Execution Plan Caching and Reuseâ' topic in the BOL.
"Jason" wrote:
> Hi,
> I'm checking my performance of sql 2000 ent. on a w2k adv. server. There
> are 2gb's of memory available. the server is dedicated for sql server
> (at least i think it is).
> I've noticed that the counter sql server: cache manager - cache hit
> ratio is on average 67-70. The counter sql server:buffer manager -
> buffer cache hit ratio is always above 99%. SQL Server uses dynamic mem
> alloc.
> All other import counters like processor and physical disk shows low values.
> Could there be a memory bottleneck where the asigned cache for sql is
> too low?
>