Post reply

Connection Pooling & Open Transactions with Sleeping Status

  • July 1, 2009 at 6:03 am

    #135853

    We are seeing processes with a status of SLEEPING, a command of AWAITING COMMAND and OPEN TRAN = 1. The development team believes this may be normal behavior for connection pooling. I believe this indicates a transaction was not properly committed. If OPEN TRAN was zero, then this would make more sense to me in terms of connection pooling behavior. Do you agree this is a problem with transactions not being completed properly?

    Thanks, Dave

  • July 1, 2009 at 7:23 am

    #1018374

    Dave, I would tend to agree with you that it should be zero. Sorry, out and about with no instance to test on right now.

  • July 1, 2009 at 7:27 am

    #1018376

    Hi Steve,

    I just found a quote from Kalen regarding open transactions.

    The need for examining the open_tran value is greatest when looking at those sessions that aren't doing anything, but are just sitting there with an open transaction. Those are the processes that you need to troubleshoot.

    Now it's on to troubleshooting the open transactions.

    Dave

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply