Re: How to clear connection pool?

In V1.1, you can't force the SqlClient connection pools to be cleared. The
most you can do is return the connections to the pool and wait for them to
expire.

--
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.


"Jeff Clausius" <jeffc@xxxxxxxxxxxxxx> wrote in message
news:Xns967B5450EEBF5jeffcsourcegearcom@xxxxxxxxxxxxxxxx
> Srinivas:
>
> This feature may or may not be configurable based on your back end
> database.
>
> For instance, in the example I gave, modifying the connect string used by
> SQLConnection (SQL Server database), the pool size can be configured. It
> can be turned on/off (Pooling), as well as controlled by 'Max Pool Size'
> and 'Min Pool Size' attributes. For the SQL Server example, see
> SQLConnection.ConnectionString within .Net Help.
>
> HTH
> Jeff Clausius
> SourceGear
>
>
> "=?Utf-8?B?YWU=?=" <ae@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> news:2D43745D-0D8F-4448-A70D-1903CC891609@xxxxxxxxxxxxx:
>
>> Jeff, how does one control the max size of a pool are you saying limit
>> the output results? Also, is there a max of results that can be
>> returned? How do I measure that if so.
>>
>> "Jeff Clausius" wrote:
>>
>>> Srinivas:
>>>
>>> I can see where some people would *think* you are losing connections,
>>> but from your description, that does not seem to be the case. One
>>> possible solution is controlling the max size of your pool through
>>> the connect string.
>>>
>>> For instance, we have some customers using Vault server for about
>>> 150-200 users. In a couple instances, there have been pool
>>> connection problems when 100+ people have been connecting to the
>>> database within the same time frame. There are no connection leaks
>>> in the server. This was just an instance of a large amount of users
>>> accessing the database.
>>>
>>> HTH
>>> Jeff Clausius
>>> SourceGear
>>>
>>> "Srinivas Kollipara" <skollipara@xxxxxxxxxxxxxxxxxxx> wrote in
>>> news:OpuGn7pcFHA.2760@xxxxxxxxxxxxxxxxxxxx:
>>>
>>> > Hello all,
>>> > I am wondering how to clear the connection pools from C# program,
>>> > because my program everytime it runs , it needs 70 connections...
>>> > so whenever my project fails i wanted to reset connection pools, or
>>> > else after 3 to 4 runs, i am getting an error "The timeout period
>>> > elapsed prior to obtaining a connection from the pool. This may
>>> > have occurred because all pooled connections were in use and max
>>> > pool size was reached". then if i reboot it will be ok, i dont want
>>> > to rebbot machine for this reason.. i heard a while back that this
>>> > feature is included in .NET 2.0, can any one knows that it has that
>>> > feature. can some one help me on this, how to do it.
>>> >
>>> > Thanks
>>> > Srinivas
>>> >
>>>
>>


.

Relevant Pages

  • Re: Where is the database connection pool locating?
    ... authentication. ... Pool Fragmentation Due to Integrated Security ... Connections are pooled according to the connection string plus the user ... Although this improves the performance of subsequent database ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to clear connection pool?
    ... SQLConnection (SQL Server database), the pool size can be configured. ... >> connection problems when 100+ people have been connecting to the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle Connectivity/Windows Service
    ... OracleConnection probably maintains a connection pool, ... When you restart the database server, ... Does restarting your Windows Service machine help? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Statement Class Helper request
    ... SQL Server will do this as well for regular queries issued ... > connection (there is also the notion of "preparing" a query for use multiple ... One advantage of using Java for the connection pool - this doesn't seem ... > I agree with you that there are ways you might want to filter the query. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Close and Dispose argument
    ... > fact that even Microsoft is not clear on the issue. ... > connections from the pool is still a debate. ... > method removes the conneciton from the connection pool". ... > Your issue was forwarded to us here at Microsoft Courseware Support. ...
    (microsoft.public.dotnet.framework.adonet)