I'm running IIS on Server 2008 R2. Recently, I've seen a lot of errors like this:
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.
When I go into the IIS manager and look at the worker processes, I see that this application pool has a bunch of requests that have been running for over an hour each. I'm guessing that they're holding on to db connections, which is why nobody else can get one.
So, two questions:
- Why didn't IIS timeout and kill off these requests? (They normally complete in 1 - 2 seconds.)
- How do I make sure this doesn't happen?