web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Azure SQL database ser...

Small and medium business | Business Central, N...

Suggested Answer

Azure SQL database service and jet Report issue

(1) Share

Report

Report

Posted on by siong

14

Hi

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 ?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Vahid Ghafarpour 12,266 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 677 Super User 2026 Season 1

#2

Gerardo Rentería Ga... 447 Most Valuable Professional

#3

YUN ZHU 366 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans