Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Win2003 IIS6 .NET3.5 ASP.NET , +
We have deployed Asp.net Application in Windows 2003 R2 server 64 bit and IIS 6.0.

The user login this application after 10 min, he is getting below mentioned error.

"Timeout expired. 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."

In application side, We have increased connection pool Min size = 200 and Max size = 50000.

System side, we executed below script.

cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1

Please suggest me to over come this issue.
thanks.
Posted 12-Jan-12 0:11am
Edited 12-Jan-12 0:18am
v2
Comments
B Birajdar at 12-Jan-12 10:38am
   
Have you tried setting the timeout in IIS?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi,

The error is due to the retrieval of data from database

Try setting the connectiontimeout property in your connection string

Also increase the time out in IIS

Fine tune your db queries

Hope this helps
  Permalink  
Comments
NandaKumer at 13-Jan-12 1:27am
   
good one
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Add Max Pool Size in your connection string
ex:-
<add name="entityConnection" connectionstring="metadata=res://*/EntityDB.csdl|res://*/EntityDB.ssdl|res://*/EntityDB.msl;provider=System.Data.SqlClient;provider connection string="Data Source=ServerName;Initial Catalog=DB_Name;Persist Security Info=True;User ID=sa;Password=password;<b>Max Pool Size=500</b>; MultipleActiveResultSets=True"" providername="System.Data.EntityClient" />
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 475
1 Sergey Alexandrovich Kryukov 405
2 Maciej Los 290
3 ProgramFOX 265
4 CHill60 200
0 OriginalGriff 490
1 Sergey Alexandrovich Kryukov 405
2 Maciej Los 285
3 ProgramFOX 265
4 Peter Leow 210


Advertise | Privacy | Mobile
Web01 | 2.8.150331.1 | Last Updated 6 Jan 2014
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100