Re: STATSPACK - Rollback per transaction %

  • From: BN <bnsarma@xxxxxxxxx>
  • To: ken.payton@xxxxxxxxxxxxxxxxxx
  • Date: Wed, 28 Dec 2005 11:41:45 -0500


Thank you all for your Reply.

Ken You are right, thats what they are doing.

Regards & Thanks

On 12/28/05, Ken Payton <ken.payton@xxxxxxxxxxxxxxxxxx> wrote:
> You might want to check your application connection pooling.  A
> connection pool might rollback a pre-established connection before
> returning it to the pool, regardless of whether something is being
> rolled back or not.  If your application is constantly requesting and
> releasing connections from the pool the number of rollbacks would grow
> significantly.  Especially if many of the connections are only
> performing queries and have not performing any transactions the
> percentage of rollbacks to transactions would be extremely high.  In
> this case, since you do not actually have anything to rollback you are
> probably fine.
> Kenny
> --
> Kenny Payton
> Software Architect
> Public Records Group
> Choicepoint, Inc.
> ken.payton@xxxxxxxxxxxxxxxxxx
> o: (770)752-4054
> -----------------------------------------
> The information contained in this e-mail message is intended only for
> the personal and confidential use of the recipient(s) named above. This
> message may be an attorney-client communication and/or work product and
> as such is privileged and confidential. If the reader of this message
> is not the intended recipient or an agent responsible for delivering it
> to the intended recipient, you are hereby notified that you have
> received this document in error and that any review, dissemination,
> distribution, or copying of this message is strictly prohibited. If you
> have received this communication in error, please notify us immediately
> by e-mail, and delete the original message.

Regards & Thanks

Other related posts: