Al Wahda Distribution: order entry crawls and ends in “Execution Timeout Expired”

Al Wahda Distribution, a food wholesaler in Oujda (deliveries to Nador, Berkane and Taourirt), enters orders from its 600 grocers in a web ERP connected to an Azure SQL Database erp_alwahda (server sql-alwahda, resource group rg-alwahda-erp, Standard S2 tier, 50 DTU).

On Friday evening, the team released a new sales dashboard, displayed permanently on the screens of management and the sales staff.

Since Monday 08:00, the ERP has been very slow and the sales staff see “Execution Timeout Expired”. The finance director suggests “going Premium” right away. Before multiplying the bill, you are asked to understand what is happening. You have the Azure CLI and sqlcmd (Microsoft Entra administrator account).