Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kiransuthar
Starting Member
9 Posts |
 Posted - 2008-11-07 : 11:11:06
|
| Hello, Many time I am getting error on my site. Full error message is as below,"Timeout Expired. The timeout preiod 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."many times this error comes in Java script alert on page. and many time it is thrown as a exception during DB operation.My site is using ASP.NET 2.0 AND SQL Server 2005How can I find the reasons of it? Please help me, I can't figure the problem.ThanksKiran Suthar |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-07 : 11:20:38
|
| it may be because query is taking too long to execute and server timeout period was exceeded because of that. what was query you ran when you got this error? probably worth trying to execute query directly in Query Analyser and see any performance bottlenecks. |
 |
|
|
kiransuthar
Starting Member
9 Posts |
Posted - 2008-11-07 : 11:35:18
|
| Hello Visakh Thanks for the quick reply.Time out is not occurring all the time and it is not fixed to any specific page. so I guess problem is not with the any specific query. Error comes on any page any any time. and same page works fine after some time. Thats why I am surprised and frustrated for this problem.ThanksKiran |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-07 : 11:54:54
|
| that may be because server is busy with too many requests. Is server in a clustered environment or is it standalone? |
|
|
|
kiransuthar
Starting Member
9 Posts |
Posted - 2008-11-07 : 12:08:16
|
| Hi, We have Stand Alone SQL server.DB serve and Application server both are same. server has many other sites with good traffic but other sites such error is not coming.Thx,Kiran Suthar |
|
|
|
|
|
|
Time out Expired