The stored procedure ran fine in SSMS — under 1 second, every time. But through the .NET API? 30–120 seconds. Timeouts. Errors.
A production system started timing out. The stored procedure ran fine in SSMS — under 1 second, every time. But through the .NET API? 30–120 seconds. …