Fix EF Core idle slowdown by tuning SQL Server connection pooling
Summary After an ASP.NET Core application sits idle, EF Core queries against SQL Server become dramatically slower. The culprit is almost always connection pooling combined with SQL Server’s connection idle timeout and login timer delays. The keep-alive hosted service workaround works, but it masks a deeper connection configuration problem that should be solved at the … Read more