Click here to Skip to main content
11,704,768 members (48,574 online)
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 11-Jan-12 23:11pm
Edited 11-Jan-12 23:18pm
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 Sergey Alexandrovich Kryukov 679
1 OriginalGriff 455
2 Andy Lanng 245
3 CPallini 242
4 Maciej Los 225
0 OriginalGriff 8,864
1 Sergey Alexandrovich Kryukov 8,245
2 CPallini 5,189
3 Maciej Los 4,726
4 Mika Wendelius 3,606


Advertise | Privacy | Mobile
Web01 | 2.8.150819.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