un-removed SQL Server activity item (connection?) after ADO.Net connection closed RRS feed

  • Question

  • Hi there,


    We have IIS based .Net server app accessing SQL Server through ADO.Net 2.0. One of our issue now is that after the app finishs running, there are always SQL Server "activities" left on the database server. We can see that by running SQL Server's Activity Monitor. In the begining I thought they were un-closed ADO.Net connections. But when I step through the code, I realized that it is not the case. Even when the connections is closed (the state of the connection object is closed), the "activity" is still there and the activity's status is "sleeping" and its Command is "AWAITING COMMAND". It seems that the only way that I can get rid of them is by doing a IISRESET on the machine where my app is running (my app is hosted under IIS).


    What is going on here? Am I missing somthing?


    Thanks in advance!



    Wednesday, November 14, 2007 11:52 PM


  • Never mind. I think that's because I am using the connection pooling...





    Thursday, November 15, 2007 4:06 PM