SQL Server Performance

SQL Server 2005 and SQL Error 3971

Discussion in 'SQL Server 2005 General Developer Questions' started by Thona, Sep 13, 2006.

  1. Thona New Member

    I have a problem driving me mad for about half a year now.

    We have a number of web based applications. These are making tons of sql statements, all in a transaction that is absolutly disposed of afterwards. It is all programmed in C# using the "using" keyword.

    Whenever the application pool hosting the site does reset, SQL connections we open seen unresponsive. I get a list of errors that look like:

    The transaction active in this session has been committed or aborted by another session.)

    In C# terms it is a SqlException that reads:

    Server failed to resume the transaction, desc: 360000023c.

    and it contains Error Number: 3971

    I seem to be unable to get this operation to run. After some time it seems that the connecitons get "closed" and turn usable again. I think that the application pool cycle leaves partially open connections in the pool, and when I close the pool, the connection gets closed.

    Sadly, there seems to be no proper documentation on this on the internet. Anyone has experienced something similar? I am trakcing this for like 6 months now.
  2. rkadiyala New Member

    hi i am also facing the same issue. could you please let me know if you found any solution to this

    Thanks,
    Raj.

Share This Page