ADSM-L

Re: DB Cache Hit Rate Question

2003-02-19 14:33:05
Subject: Re: DB Cache Hit Rate Question
From: Richard Sims <rbs AT BU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 19 Feb 2003 14:31:54 -0500
>...Should the cache hit rate consistently be above 98%? ...

In a single word: No.  The 99%+ is the fairy tale objective.
You'll find numerous postings in the List archives advising of
the real world behavior of caches which, as you've seen with
Backups, cause the number to drop, as one should expect with a
large number of such unique accesses.  The best we can do is
dedicate as much *real* memory as feasible to maximize the
number during steady-state operations.

Don't get over-absorbed in Cache Hit Ratio: It's just one
factor among the many that a systems person has to address to
maximize server throughput.  Your time needs to go into a lot
of other issues as well.

  Richard Sims, BU

<Prev in Thread] Current Thread [Next in Thread>