Re: Performance problem immediately fixed by disabling HDR
Posted in 2007
Topics: High Availability & Replication, Performance & Tuning, Logging & Checkpoints, Platform-Specific Issues, Versions, Editions & End-of-Life
"Fernando Nunes" <spam@domus.online.pt> wrote in message
news:f9atdb$7ev$2@aioe.org...
> Neil Truby wrote:
>> IDS 10.0FC5 on AIX 5.3
>>
>> We have a highly sporadic performance problem. Sporedically - hasn;t
>> happened for a couple of months but has started today - our database
>> server starts exhibiting 2 sec checkpoints (otherwise they are almost
>> always 0s) and the performance of critical processes dives.
>>
>> 14:01:19 Checkpoint Completed: duration was 2 seconds.
>> 14:16:21 Checkpoint Completed: duration was 2 seconds.
>> 14:31:24 Checkpoint Completed: duration was 2 seconds.
>> 14:46:26 Checkpoint Completed: duration was 2 seconds.
>> 15:01:28 Checkpoint Completed: duration was 2 seconds.
>> 15:16:31 Checkpoint Completed: duration was 2 seconds.
>> 15:31:33 Checkpoint Completed: duration was 2 seconds.
>> 15:46:35 Checkpoint Completed: duration was 2 seconds.
>> 16:01:37 Checkpoint Completed: duration was 2 seconds.
>> 16:16:40 Checkpoint Completed: duration was 2 seconds.
>> 16:31:42 Checkpoint Completed: duration was 2 seconds.>>
>> <== HDR turned off at 1642
>> 16:46:43 Checkpoint Completed: duration was 0 seconds.
>> 17:01:42 Checkpoint Completed: duration was 0 seconds.
>> 17:16:43 Checkpoint Completed: duration was 0 seconds.
>> 17:31:43 Checkpoint Completed: duration was 0 seconds.
>> 17:46:44 Checkpoint Completed: duration was 0 seconds.>>
>>
>> As before, turning HDR off immediately clears the problem. There are no
>> obvious performance problems on either PRI or SEC server. It's all a
>> mystery. The common thread is that shutting off HDR fixes it instantly.
>>
>> Any observations?
>>
>> thx
>
> Try pinging between servers to check for any TCP/NET issues..
> Regards
We've had it again this evening. Before disabling HDR- which again
instantly cured the problem - I pinged from Pri->Sec - 0ms constantly.
I also did onstat -a and onstat -g all on both servers before disabling if
anyone's interested ......
Neil Truby wrote:
>
> We've had it again this evening. Before disabling HDR- which again
> instantly cured the problem - I pinged from Pri->Sec - 0ms constantly.
>
> I also did onstat -a and onstat -g all on both servers before disabling if
> anyone's interested ......
>
>
Neil,
Open a case on this and attach the onstats to the case.
Thx
M.P.
"Madison Pruet" <mpruet1@verizon.net> wrote in message
news:46BA2A8F.70405@verizon.net...
> Neil Truby wrote:
>
>>
>> We've had it again this evening. Before disabling HDR- which again
>> instantly cured the problem - I pinged from Pri->Sec - 0ms constantly.
>>
>> I also did onstat -a and onstat -g all on both servers before disabling
>> if anyone's interested ......
>
> Neil,
>
> Open a case on this and attach the onstats to the case.
Hi Madison
Thanks
There is a case, 33150,019,866.
However, other than by emailing it to UK support, who have gone home, I
can't get the stats attached to it I don't think.