Re: STATSPACK - Rollback per transaction %

Greetings

Thank you all for your Reply.

Ken You are right, thats what they are doing.

Regards & Thanks
BN

On 12/28/05, Ken Payton 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_at_choicepointprg.net
> 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
BN