Re: Serious performance problems with large BUFPOOLSIZE
2006-01-27 14:13:54
On Jan 27, 2006, at 1:54 PM, Allen S. Rout wrote:
Sounds like that would make a fascinating chart.
And the recommended formula would have led you to something like 20G,
right?
With the really slow points, was the cache hit percentage good?
Something else that could be interesting is to set server option
SELFTUNEBUFpoolsize Yes
and see what the server comes up with as its own value.
Richard Sims
|
|
|