Azure Functions and Sql Trigger scaling

[waynebrantley]

Sql Trigger scaling does not seem to work. It will not not scale up from 0 to 1 (so probably likely it would not scale from 1 to x).

The list of target based scaling options appear to all be supported with azure functions in ACA as shown here.

According to the documentation for Sql Trigger, this uses target based scaling. It is not listed on the target based scaling page for some reason though and when deployed as a container it will not scale up.

Everything seems to work fine, except it will not scale up from 0 to 1 (so probably likely it would not scale from 1 to x). Am not sure if this is a bug or if this is a missing scaling option that needs to be added.

[anthonychu]

@raorugan can you please help with this?

[raorugan]

If you are looking for scale from 0 to 1 for sql trigger in azure container apps , this is in the roadmap. May I know how critical requirement is this? Would provisioning min replicas work?

[waynebrantley]

We are setting the min replicas to 1 in production, but it will not scale more than 1.
Also, in our test environments we are forced to keep it at one, which means it never scales to 0 when testing is not being done, etc.

Glad this is on the roadmap, but it would be super helpful if the roadmap here was used/updated/managed https://github.com/orgs/microsoft/projects/540/views/1