An exception has been raised that is likely due to a transient failure

Tags: #<Tag:0x00007f185fc58ea0>

I am upgrading to 1.7.0. Following migration guide. Local SQL is running okay, while deploying to azure I am getting spammed with:

An exception has been raised that is likely due to a transient failure. Consider enabling transient error resiliency by adding ‘EnableRetryOnFailure()’ to the ‘UseSqlServer’ call. <— Resource ID : 1. The request limit for the database is 60 and has been reached. See ‘’ for assistance.

How can I solve this now?

Also getting lot of traces
Entity Framework Core 2.2.4-servicing-10062 initialized 'ApplicationDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: MaxPoolSize=128

Does it have something to do with setting: QueuePollInterval = TimeSpan.Zero

How can I solve this now?

I got my app service back running by removing provided SqlServerStorageOptions() in docs.
I am not sure why docs are recommending following settings:
new SqlServerStorageOptions
CommandBatchMaxTimeout = TimeSpan.FromMinutes(5),
SlidingInvisibilityTimeout = TimeSpan.FromMinutes(5),
QueuePollInterval = TimeSpan.Zero,
UseRecommendedIsolationLevel = true,
UsePageLocksOnDequeue = true,
DisableGlobalLocks = true

while default options for SqlServerStorageOptions are completely different…