Most API latency problems = opening too many SQL connections.
🚀 Fix
Use a single pooled client:
builder.Services.AddDbContext<AppDb>(options =>
options.UseSqlServer(connString, o => o.EnableRetryOnFailure()));
✨ Benefits
-
⚡ Fast connection acquisition
-
📉 Lower CPU
-
🧵 Stable high-load behavior
💡 Bonus
Use Max Pool Size=200 in connection string for heavy systems.