Monitoring open Sql connection in IIS

Question

User-106925610 posted

Long story short - I have the below error.

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.

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

Answer 1

User690216013 posted

https://stackoverflow.com/questions/670774/how-can-i-solve-a-connection-pool-problem-between-asp-net-and-sql-server

All necessary tools were mentioned.

Answer 2

User1065476709 posted

Hi SAcod3,

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.

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/performance-counters

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

Best regards,

Sam