We had our DB in Azure. When we ran a batch background job it was slow as heck once we exceeded 20 jobs in the batch or so… Even on a Standard Azure SQL db, not even Basic…
We installed SQL 2016 on an Azure web server to test the difference, and now this baby flies…
We were getting the insidious “SQL exception / timeout error” when this DB was in Azure SQL…
If anyone has a better fix we’d love to hear it!