How much memory does task manager say that sqlserver.exe is using?
Do you have /PAE enabled or /3GB in the OS boot.ini?
How many concurrently users are there? Are they accessing similar data or
does everyone access different data?
Taking advantage of cache is only possible when you are re-reading data you
have already read before. If you are always going after new data, the size
of cache doesn't matter.
How long has SQL Server been running? Are you sure it's reached a steady
Can you try running a large query and looking at the statistics IO? Then
rerun the same query and note the number of physical or read-ahead IO's. If
you repeatedly get physical or read-ahead IO on the same query, then your
cache is not being effectively used.
SQL Server MVP
> I have a Compaq running advanced server 2k, sql server 2k
> enterprise edition sp2. 4 2ghz processors 6gb ram. 4.5gb
> is dedicated to sql. awe is enabled. The cache hit ratio
> is at 8%. there is a fair amount of reading from disk. how
> do I get this setting above 90%. What setting do I need to