Share via

Delay in Activating Azure Function with Sql Trigger

Joao Pedro Alves 60 Reputation points
2024-01-31T12:25:40.42+00:00

I'm having an issue with an Azure Function. It's a Consumption Plan Function and has been configured with the Sql Trigger. I know there's cold start initialization, which takes some time until the Function is provisioned, but there have been times when the Function wasn't triggered for an entire weekend, even though there were changes in the database. It only started when I opened the Function in the Azure Portal. Could you please explain what might be happening? I appreciate it in advance.

Azure Functions
Azure Functions

An Azure service that provides an event-driven serverless compute platform.

Developer technologies | .NET | Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Pramod Valavala 20,661 Reputation points Microsoft Employee Moderator
    2024-02-01T17:28:25.8033333+00:00

    @Joao Pedro Alves This seems to be a drawback for the SQL Trigger with Consumption Plans and is called in the trigger reference for the same. You would have to use the Premium or Dedicated Plans as mentioned. Based on your observations, the function app is processing rows while the function app is scaled to at least one instance either when you trigger when opening the function app in the Azure Portal or if another function gets triggered by an event.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.