My team and I are trying to validate that when a sql DB is getting an insert it should trigger a azure function by SQL DB Trigger. Right now there is two sites, more to come in the future, that are using this function to process some records, not a couple hundred but a couple hundred thousands of them each day. Our concern is that with each function trigger is triggering multiple instances every time there’s an insert in the DB.

My question is that if there’s 5 sites that are using the same function is it possible that azure functions can handle so many requests? My understanding is that it can. Also would it be possible that, with so many sql triggers happening, it could be stepping on it’s toes and possibly adding an insert when another instance wasn’t finished?

Just need some clarification on my end.