Re: testing memory parameters

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Mon, 17 Mar 2008 22:31:59 -0400
Message-ID: <648nt2F29qdldU1@mid.individual.net>

DA Morgan wrote:
> Serge Rielau wrote:

>>> Below what value is BCHR "bad"?
>> In DB2 I treat any OLTP app with less than 90% hit ratio as troubled.
>> Anything less than 80% I'd call a mess requiring some serious 
>> explanation.

>
> Because, in DB2, you don't have sufficient instrumentation to look
> inside and see what is happening.

Ah, Daniel, you never fail to live up to my expectation of taking a cheap shot wherever you can. What would you know about DB2's state of perf tuning tools...
But I digress. I got the answers I needed.

Thanks Ana
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Received on Mon Mar 17 2008 - 21:31:59 CDT