Re: Cache Hit Ratio

From: Phil Herring <revdoc_at_uow.edu.au>
Date: 1998/01/06
Message-ID: <68ucv7$l99$1@wyrm.its.uow.edu.au>#1/1

There are two possible fixes:

1. Don't shut down for your backups. This will eliminate the problem altogether.
2. Careful programming of an initialisation script may reduce the problem to some extent, but won't make it go away. This is what you would have to do:
   • Pin your largest, most-used packages at startup.
   • Run queries that select the "active" rows in your OLTP data.
   • Run SQL queries that do full table scans on any small code tables.

The second step is the most important for your hit ratio, and is also the hardest to do, as it may be difficult to determine your most active data. That's why I wouldn't bother with with this solution (although pinning packages is usually a good practice).

---

Copyright 1998 Phil Herring. This article may not be reproduced for profit.

---

Received on Tue Jan 06 1998 - 00:00:00 CST