Re: ADO.NET and Sleeping processes

From: AMerrell (anonymous_at_msnews.microsoft.com)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 14:09:09 -0600

Yeah, The reason I'm wanting to keep polled conections is because of this statement: "Pooling connections can significantly enhance the performance and scalability of your application." My problem is that even when I close the connection it doesn't seem to be releaseing it back to the pool.

My understanding is as long as the connection string doesn't change it should take the next available pooled connection. Instead what it's doing is just creating another pooled connection and sleeping. I eventually hit the max pool size and all applications stop responding.

What I'm trying to figure out is why my connection is not being release back to the pool. Correct me if I'm wrong but I do believe my code does close the connection.

>>> Patrice<nobody@nowhere.com> 2/1/2005 12:12:20 PM >>>
What you see is likely the pooling feature :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconconnectionpoolingforsqlservernetdataprovider.asp

Adding "pooling=false" in your connection string should disable pooling...

Patrice 

-- 
"amerrell" <anonymous@msnews.microsoft.com> a écrit dans le message de
news:eU1yQdICFHA.2072@TK2MSFTNGP10.phx.gbl...
> How can I prevent the flood of sleeping processes that occur from my
database queries using datareaders?
>
> Here is how I make my connections am I doing somehting wrong?
>
>
> Dim myConnection As New SqlConnection(GetAppSetting("DBCon"))
> Dim myCommand As New SqlCommand("Select * from table where column =
@column", myConnection)
> myCommand.Parameters.Add("@column", columnvalue)
>
> Try
>    Dim dr As SqlDataReader
>    myConnection.Open()
>    dr = myCommand.ExecuteReader()
>    While dr.read()
>       strVar = dr("somecolumn")
>    end while
>    dr.close()
>    myconnection.close()
> Catch ex as Exception
>    Trace.Write("SQLQuery ", ex.Message)
> End Try
>
>
> Thanks for any help...
>
> amerrell

Relevant Pages

  • Re: ADO connections question
    ... Function CreateADOObjects(ConnectionString as string) ... you'll see this error if the connection has not been ... I have a specific login form that calls the dbLogin function as shown ... Dim strCriteria As String ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Updating Access data using SQL / refresh time question
    ... As a test today, for one poarticular recordset, I changed from DAO to ADO to ... > I forgot to mention that the expense of repeated connection open and close ... > dim oconn as new adodb.connection ... > 'Now load the listview by looping through each RS row ...
    (microsoft.public.vb.database)
  • Re: Updating Access data using SQL / refresh time question
    ... > I forgot to mention that the expense of repeated connection open and close ... > dim oconn as new adodb.connection ... > 'Now load the listview by looping through each RS row ... > ' Set the recordset object each time we load the listview ...
    (microsoft.public.vb.database)
  • Re: Updating Access data using SQL / refresh time question
    ... > I forgot to mention that the expense of repeated connection open and close ... > dim oconn as new adodb.connection ... > 'Now load the listview by looping through each RS row ... > ' Set the recordset object each time we load the listview ...
    (microsoft.public.vb.database)
  • Re: ExecuteReader requires an open and available Connection.
    ... you have ALL your users sharing one connection. ... Public Shared Function GetServerAs String ... Dim theServer As String ...
    (microsoft.public.dotnet.framework.aspnet)