Re: ODBC/OLE DB Connection Pool

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 11/27/04 

Date: Sat, 27 Nov 2004 06:49:26 -0500

Kevin Joseph wrote:
> If connection pool is setup on the client, it is possible to monitor
> the SQL server connections using perfmon - if the connections grow ;
> it means that connection pooling is not working. And this is exactly
> what is happening in my case. If you have some other way of proving
> that connection pooling is fine ; I will gladly accept your point of
> view.
>
Darn. I forgot to mention that it is fairly easy to prove that pooling is
working by using SQL Profiler to verify whether your connections are being
re-used.. You can even use sp_who2 to verify that your connections remain in
place for 60 sec. after you web pages use them (Create a test login name.
Create a test page that uses that login. Run the page. Then use sp_who2 in
Query Analyzer to see the connection. Run sp_who2 to verify that the
connection remains. Refresh the page. Use sp_who2 to see if a new connection
gets created).

Bob Barrows 

-- 
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Relevant Pages

  • Re: ado connection object in vb6
    ... "Global connection objects are bad in so many ways. ... The key is that ADO uses 'connection pooling'. ... "Pooling in the Microsoft Data Access Components" ...
    (microsoft.public.vb.database.ado)
  • Re: SQL Resets
    ... When we turn on connection pooling, it loads up pretty fast to throw the ... I tend to believe it has something to do with the connection pooling. ... Have you had a look at the SQL Server ... Have you tested the development environment with MaxUserPort=64534, ...
    (microsoft.public.sqlserver.connect)
  • Re: MDAC question
    ... The MDAC downloads are labeled by the ... I suggested that the ADO data library is ... He simply created a connection object and set its connection time ... Connection pooling is just the kind of 'hidden' ...
    (microsoft.public.data.ado)
  • Re: MDAC question
    ... The MDAC downloads are labeled by the ... I suggested that the ADO data library is ... He simply created a connection object and set its connection time ... Connection pooling is just the kind of 'hidden' ...
    (microsoft.public.vb.database)
  • Re: Connection issues
    ... Connection pooling will have no impact on performance in a Windows Forms ... Test for errors on the server by checking @@Error. ... > one SP inserts a row with an identity column. ...
    (microsoft.public.dotnet.framework.adonet)