MaxPoolSize vs. Connection Lifetime: Which Better Prevents Intermittent Pool Exhaustion?
Goal Identify the most effective mitigation for intermittent SqlClient pool exhaustion in a .NET application. Constraints Server resources are limited; excessive pooled connections can strain memory and CPU. Connection leaks (unclosed SqlConnection objects) are suspected but not confirmed. Latency must remain acceptable under burst traffic. Uncertainty Both
csharp