Intermittent issues in Orchestrator UI because of DTU consumption of the database(hosted in azure) reaching 100%

How to resolve the Intermittent issues in Orchestrator UI because of DTU consumption of the database(hosted in azure) reaching 100% ?

 A few observed scenarios are mentioned below.

  1. Intermittent "An error occurred" issue in license page
  2. Intermittent "An error occurred" issue in logs page.

The issue is because the SQL server is hosted in Azure and it's DTU consumption was 100% which was making all the execution slow which in turn resulted in timeout error during execution of sql query. DTU is a measure; a blend of CPU memory and IO. 

As per Microsoft's guideline, For maximum storage of 100 GB, there must be around 100 DTUs . The issue would be resolved after increasing the DTU's count.

 

For more details,Refer the SQL Database Service Tiers DTU .