drunkahol
New Member
Today I checked a database at a client that has been running happily for around 4 years.
It is averaging just over 4 checkpoints per MINUTE during it's 20 hour uptime each day.
Two things -
(1) is this a record?
(2) how the hell do I reduce it since the client already has APW's and BIW's running?
I've tuned checkpoints successfully in the past, but never come across a problem quite as bad as this.
The database is 8.3B running on HP-UX 10.something
The database is a planning database and does a HUGE amount of record updates throughout the day which we cannot (I am told) avoid.
Thanks
Duncan
It is averaging just over 4 checkpoints per MINUTE during it's 20 hour uptime each day.
Two things -
(1) is this a record?
(2) how the hell do I reduce it since the client already has APW's and BIW's running?
I've tuned checkpoints successfully in the past, but never come across a problem quite as bad as this.
The database is 8.3B running on HP-UX 10.something
The database is a planning database and does a HUGE amount of record updates throughout the day which we cannot (I am told) avoid.
Thanks
Duncan