How to resolve the Intermittent issues in Orchestrator UI because of DTU consumption of the database( hosted in Azure) reaching 100% ?
Issue Description:
A few observed scenarios are mentioned below:
- Intermittent "An error occurred" issue on the license page
- Intermittent "An error occurred" issue on the logs page.
Root Cause:
The SQL server is hosted in Azure and it is DTU consumption was 100% which was making all the execution slow which in turn resulted in a timeout error during the execution of the SQL query.
DTU is a measure; a blend of CPU memory and IO.
Resolution:
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 to the SQL Database Service Tiers DTU.
Additionally, follow the database maintenance considerations on the official documentation for the specific version of Orchestrator which is affected.