Azure SQL database service and jet Report issue

(1) Share

Report

Posted on by siong

using the business central 23 connect to azure SQL database S6 , we found issue during run jet report at 7 am to 10 pm , jet Report run about 20 min and hit the error(Odata connect jet Report ), check azure SQL database DTU max only 10%.

but if run same report at after 10 pm , the Report just need 2min and run success. any recommend ? this azure SQL database issue ?

All responses (1)

Answers (0)

Suggested answer

Vahid Ghafarpour 11,742 Super User 2025 Season 1 on at

Like (2)

Report

Azure SQL database service and jet Report issue

Use Azure's monitoring tools to track CPU, memory, and I/O usage. This can help identify if there are specific queries or processes causing the spike in DTU usage.

https://techcommunity.microsoft.com/t5/azure-database-support-blog/what-caused-the-sudden-dtu-cpu-spikes-to-the-limit/ba-p/811218