Re: Connection Pool Issue

Max pool size 10 seems low... My personal preference is to avoid messing
wiht default values unless I'm 100 % sure it's worth. What if you try the
"perfmon.exe" to check pooling counters ?

My first thought would be that connection poolling is actually disabled on A
making this problem invisible while it is enabled on B showing the problem
because of the low connection count ?

Good luck. Seems hard to diagnose....

--
Patrice


"Kerry" <Kerry@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message de groupe
de discussion : B13D42D3-DBAB-41E0-86F6-C6DB1132D602@xxxxxxxxxxxxxxxx
Hello, I'm having a problem with connection pooling from my ASP.NET Web
Service. I have two identical servers (Software wise, hardware is
different).
Server A and Server B both are running Windows 2000 Server sp4, Framework
2.0.50727 and 1.1.4322, IIS 5 and using the .Net SqlClient Data Provider.

When connecting via my .NET client app to the service on Server A the DB
connections to SQLServer 2005 sp2 re-uses the connections perfectly
however
when connecting to ServerB which runs the exact same service connections
are
being used up then I get the dreaded "The timeout period elapsed prior to
obtaining a connection from the pool. " I have compared both servers and
cannot find the difference...I'm thinking somewhere down the line I
installed
something which enabled connection pooling to function correctly on
ServerA...ServerB is new server which will replace ServerA. I have checked
all the usual places for enabling connection pooling. With each DB read
operation the connections are being used up as if it thinks each read is
coming from a different user.

1. Both Machines do not have a registry entry for StartConnectionPool = 1
so
since it works on ServerA I assume ServerB does not need it , I created
this
just in case with no luck so I removed it.

2. Connection string on both servers use Max Pool Size=10;Min Pool Size=1,
since this is Development 10 is sufficient and again ServerA runs fine
with
this, i don't even need to specify connectionpool=true property.

3. Going to the ODBC Adminstrator, Connection Pooling is 'On' for the
Drivers SQLServer(200.85.1128) and SQL Native Client(2005.90.3042) on
both
Servers. Connections are set to remain in the pool for 60 seconds.

Is there something I could be missing or some utility that could turn on
connection pooling for the .Net SqlClient Data Provider...registry
entry,config file, IIS5 command line param.

Thanks


.

Relevant Pages

  • Re: Random database connectivity failure
    ... We can’t find any problems with the pooling, that it uses to many resources. ... pointing to its not a pool problem. ... The server is only used for this web-application, ... white paper on handling the connection pool on my website. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Outgoing POP3 email missing/lost/not received
    ... Funny thing is that I have had this ISP for 8 years and it has always been ... It looks like when you last ran CEICW, you set the ISP's mail server to: ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot connect client to server 2003
    ... you need to reconfigure the IP schema of your SBS ... On the SBS 2003 Server open the Server Management console. ... On the Connection Type page, click Broadband, and then click Next. ... Alternate DNS server, type the IP addresses that are provided by your ISP ...
    (microsoft.public.windows.server.sbs)
  • Re: Outgoing POP3 email missing/lost/not received
    ... ISP's mail server instead of the domain name on the ... SUMMARY OF SETTINGS FOR CONFIGURE E-MAIL AND INTERNET ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)
  • Re: Networking Question - VLANs on SBS 2003 Premium SP1
    ... port on the old router so I now have a segregated WLAN. ... be sure you do not enable any DHCP server in internal network. ... On the Connection Type page, click Broadband, and then click Next. ... On the Network Connection, You must enable and configure the network ...
    (microsoft.public.windows.server.sbs)