We have our Umbraco setup on Azure with multiple scalable Frontends and one single Admin backend. We have had lots of “Lock request time out period exceeded. The statement has been terminated.” errors when users try to login/update profile/change or reset password on Frontend. To mitigate the lock request timeout errors we have set Umbraco.Core.SqlWriteLockTimeOut to 20000 in app settings.

After this when the traffic is high on website, we are seeing so much of performance degradation that login/update profile/change or reset password requests are taking more than 1 minute to respond.

Our configuration:

<add key="Umbraco.Core.MainDom.Lock" value="SqlMainDomLock" />
<add key="Umbraco.Core.LocalTempStorage" value="EnvironmentTemp" />
<add key="Umbraco.Examine.LuceneDirectoryFactory" value="Examine.LuceneEngine.Directories.TempEnvDirectoryFactory, Examine" />
<add key="Umbraco.Core.SqlWriteLockTimeOut" value="20000"/>

Umbraco version: 8.15.1

Any suggestions to improve the performance are appreciated.