I don't believe you need to reset except when you change the tunable
parameter... I haven't used the
SelfTunebufpoolsize so I am not sure how that would affect the statistic. I
would also be suspicious
about the SelfTunebufpoolsize working as advertised because of your low
cache hit percentage;
it obviously isn't working too well ;-) This stuff gets so arcane that I
just end up experimenting...
George





"Dearman, Richard" <rdearm1 AT UIC DOT EDU>@VM.MARIST.EDU> on 06/21/2001 
01:07:55
PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Fax to:
Subject:  Re: Cache Hit Pct.


My Buffpoolsize is set to 65536 and SelfTunebufpoolsize is set to yes as
well.  So I would assume it would tune itself to the right value.  I'm
thinking maybe the reset of buffpool stattistics will help.  Is resetting
of
the buffpool statistics something that need to be don everyday.  In order
to
get a true value each day.