Board index » delphi » Cache Hit Ratio Issue

2006-07-19 12:44:49 AM
delphi213
I have a customer using SQL Server 2000 Enterprise Edition on two clustered
servers (Windows 2003 SP1) with the following spec (times two):
4 x Intel Xeon Processors @ 2.7GHz
3.5GB RAM
36GB Local Hard Drives
175GB of SAN space for Data and log files
The database is around 2.5 GB.
I have a Cache Hit Ratio that is static at 70. I have never seen a Cache Hit
Ratio this low on any other customers let alone one that doesn't change.
It doesn't fluctuate at all. It has a minimum of 70, an average of 70, and
a maximum of 70 over a 24 hour period with more than 240 user connections.
This seems strange to me. Is there a setting that caps the cache hit ratio?
I would expect it to be>90.
Any comments or suggestions would be great.
 

Isaac,
While there may be someone here able to answer your question (if so that's
great - many here certainly use MS SQL), this is not a MS SQL Server support
group, it is to support access to SQL server databases in general from
Delphi (i.e. that can include Oracle, DB2, Sybase, etc).
You might be better served asking this question in one of Microsoft's SQL
Server support groups.
Isaac Alexander writes:
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"Reality is that which, when you stop believing in it, doesn't go
away." ?Philip K.{*word*106}
 

will try the MS group too.
Thanks Wayne.