ADSM-L

Long transaction commit times

1998-10-20 13:58:41
Subject: Long transaction commit times
From: "John M. Sorensen" <sorensen AT STORSOL DOT COM>
Date: Tue, 20 Oct 1998 11:58:41 -0600
I am experiencing slow performance from a client, so I
enabled some client-side tracing.

The trace data indicated that transaction
commit times were very long; in excess of 2 minutes in
some cases.  The DB cache hit % on the server is > 99%;
the log pool wait % is zero.  The server is AIX V3.1.1.5.
Backed up data goes to an uncached disk pool.
The database and logs are mirrored, but all mirror volumes
are local disk devices on the server.

Any ideas of what else to look at?  What traces might
I want to enable on the server to get more info about
what is happening?

Thanks for any help.

John Sorensen
SSSI
<Prev in Thread] Current Thread [Next in Thread>
  • Long transaction commit times, John M. Sorensen <=