Re: ODBC/OLE DB Connection Pool

From: Erland Sommarskog (esquel_at_sommarskog.se)
Date: 11/27/04 

Date: Sat, 27 Nov 2004 22:54:16 +0000 (UTC)

Bob Barrows [MVP] (reb01501@NOyahoo.SPAMcom) writes:
> 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..

And the thing to look for is calls to sp_reset_connection. If you see this
call, connections are being reused. (If you don't see any calls to
sp_reset_connection, you really don't have any pooling - or connections
occurs less than once a minute.) 

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Relevant Pages

  • Re: ODBC/OLE DB Connection Pool
    ... > 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 ... call, connections are being reused. ...
    (microsoft.public.inetserver.asp.db)
  • Re: ODBC/OLE DB Connection Pool
    ... > 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 ... call, connections are being reused. ...
    (microsoft.public.data.oledb)
  • Re: Question about Connection Pooling in ASP
    ... you almost have to deliberately turn off connection pooling in order ... As long as you are talking about storing a string in Application, ... pooling is used for all connections using that string. ... using connected recordsets, instead of utilizing GetString, GetRows ...
    (microsoft.public.inetserver.asp.db)
  • Re: How to close connection pool?
    ... Simply open connections with pooling disabled--or as suggested when ... Microsoft MVP ... pool preventing it until the user exits the application. ... so I need to set pooling to false for that action. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
    ... Here are a few options off the top of my head: ... Pooling via SQLRelay ... connections, just reduces the number of connections required. ... to take some load off of your database server. ...
    (perl.dbi.users)