Long Checkpoints, balancing network traffic across multiple Aliases 
Author Message
 Long Checkpoints, balancing network traffic across multiple Aliases

Another problem that we are having is that every 12 hours or so we see a
really long checkpoint.  At first it was 25 seconds then 36 seconds, now we
have a 41 second checkpoint.

It's very strange, every thing seems to be humming along nicely, then BAM -
a virtual slap in the face from my Informix engine.

I'm sure I am overlooking something that I should be aware of, does any one
know what may be going on?  There aren't any mass updates/inserts/deletes
going on to cause the checkpoints.

Thanks again,

Andrew

06:34:07  Checkpoint Completed:  duration was 1 seconds.
06:44:16  Checkpoint Completed:  duration was 1 seconds.
06:54:24  Checkpoint Completed:  duration was 2 seconds.
07:04:32  Checkpoint Completed:  duration was 2 seconds.
07:14:39  Checkpoint Completed:  duration was 1 seconds.
07:24:48  Checkpoint Completed:  duration was 2 seconds.
07:34:57  Checkpoint Completed:  duration was 2 seconds.
07:45:05  Checkpoint Completed:  duration was 2 seconds.
07:55:13  Checkpoint Completed:  duration was 2 seconds.
08:05:21  Checkpoint Completed:  duration was 2 seconds.
08:15:29  Checkpoint Completed:  duration was 2 seconds.
08:26:17  Checkpoint Completed:  duration was 41 seconds.
08:36:25  Checkpoint Completed:  duration was 1 seconds.
08:46:32  Checkpoint Completed:  duration was 1 seconds.
08:56:39  Checkpoint Completed:  duration was 1 seconds.
09:06:46  Checkpoint Completed:  duration was 1 seconds.
09:16:54  Checkpoint Completed:  duration was 1 seconds.
09:27:02  Checkpoint Completed:  duration was 2 seconds.
09:37:10  Checkpoint Completed:  duration was 1 seconds.
09:47:19  Checkpoint Completed:  duration was 2 seconds.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Long Checkpoints, balancing network traffic across multiple Aliases

2. Long Checkpoints, balancing network traffic accross multiple Aliases

3. Balancing network traffic.

4. Carry over of balances for Semi-additive measures across dimensions.(Long Post)

5. Re-balancing tables across multiple drive arrays

6. checkpoint during long insert blocks on sp calling long insert

7. MIN across multiple columns and multiple rows.

8. Checkpoints across different architectures

9. Network traffic generated by Stored Proc (local, and remote)

10. network traffic

11. Excessive RPC Network Traffic with ODBC Connection

12. Controlling network traffic


 
Powered by phpBB® Forum Software