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

Announcements

News and Announcements icon
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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 58

#2
David_MA Profile Picture

David_MA 53 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 36 Most Valuable Professional

Last 30 days Overall leaderboard