I'm wondering if having a very large - 1.5G - buffer cache can effect cpu usage. One of our production servers has 80000 db_block_buffers with a block size 0f 8k. I used the follwoing query to find out the status of the buffers.
Originally posted by stmontgo
Are you still using cache hit ratios? ...
Why we have not to use HR (for cache or not only).
Another question: We should not use HR ONLY.
HR is information about a db too. And with another measures,
such as wait statistics, os statistics and so on.
HR can show more data about perfomance and health of db.
We need use HR in right way.
If you read the following articles you'll see that hit ratios are not a very good indicator of system performance. In some cases very high hit ratios can indicate poor performance due to endless spins for latches.
You can still use hit ratios if it makes you happy, just make sure you follow them up with some real tests or you may find yourself out of a job.