IIS 7 and Above
Monitoring open Sql connection in IIS
Re: Monitoring open Sql connection in IIS
Apr 19, 2021 02:23 AM|samwu|LINK
This error can come from too many connection in SQL or IIS. Is there a way to monitor how many current connections open in IIS? The goal for me is see how many connection are open before I get the below error.
You can use Performance Monitor to monitor pooled connections.
"Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool.
The default value for Max Pool Size is 100. If your application is under very heavy load then this number may not be high enough. However,
it's more likely that your application code is leaking connections by not disposing of them efficiently.