CODEWITHSUNDEEP
azureazure-sql-databaseazure-functions
JuChom
JuChom

Reputation: 5989

Limit number of azure functions running concurrently

I have this setup on Azure.

I'm writing messages in the service bus, my function is triggered when a message is received and writes to the database.

I have a huge number of messages to process and I have this exception:

The request limit for the database is 90 and has been reached

I dig here on SO and in the docs and I found this answer from Paul Battum: https://stackoverflow.com/a/50769314/1026105

You can use the configuration settings in host.json to control the level of concurrency your functions execute at per instance and the max scaleout setting to control how many instances you scale out to. This will let you control the total amount of load put on your database.

What is the strategy to limit the function, since it can be limited on:

Thanks guys!

Upvotes: 0

Views: 1433

Answers (1)

Murray Foxcroft
Murray Foxcroft

Reputation: 13745

Look in to using the Durable Extensions for Azure Functions where you can control the number of orchestrator and activity functions. You will need to change your design a little but will then get far better control over concurrency. 

{
  "version": "2.0",
  "durableTask": {
    "HubName": "MyFunctionHub",
    "maxConcurrentActivityFunctions": 10,
    "maxConcurrentOrchestratorFunctions": 10
  },
  "functionTimeout": "00:10:00"
}

Upvotes: 1

Related Questions