web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SQL Trigger on Insert ...
Power Automate
Unanswered

SQL Trigger on Insert - When enabled to Azure hosted SQL DB, the DTU spikes to max

(0) ShareShare
ReportReport
Posted on by 49

Hello,

I'm trying to build a simple flow that is triggered when a new record is inserted to a table. It takes this record and passes it through a SP on a different DB hosted in Azure then inserts some data to another table based on the results. The DB it is triggering off of is using a standard DTU model (100) and doesn't seem to spike beyond 50% ever. Right when I enable the flow, the server spikes to 100% utilization. I have tested this over the last few days and it spikes every time it is turned on then comes right back down when I disable it. 

 

Does anyone know what could be causing this? Maybe the record size of the table I have it being triggered off of?

 

Thanks

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 378 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 273 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 135 Most Valuable Professional

Last 30 days Overall leaderboard