How to set Infinite timeout for azure functions with consumption plan

0
votes

Hi Team,

Thanks in advance. I would like to know how to solve Azure timeout error

I have created a function app with Azure Sql Database in the Azure environment and I have a very long running process which is running more than 15 mins. After 10 mins azure functions returns timeout error. So, I searched it in the internet and I found 2 solutions.

1. To set time limit 00:10:00 in host.json file will resolve the issue. 
2. To change the plan from consumption to App service plan.

Current Azure Functions Settings: 1. Pricing tier : Consumption plan 2. App Version : v1.0

Current SQL DB Plan/Settings: 1. Pricing tier : Standard S0: 10 DTUs

Solution 1) I know that, In consumption plan, the maximum timeout is 10 minutes. In an app service plan, it can be indefinite.

Solution 2) I want to know If I increase my SQL Database pricing plan from Standard to premium will it solve Timeout error?

Solution 3) Increasing the DTU's in Standard plan can solve my issue or not. If Yes, How many DTU's should I need to increase to solve my timeout error.

I want to know is there any other method we can overcome this timeout issue other than 3 solutions provided above. I spent more time on the internet but nothing works. As all the above service cost more I want to get some experts to help before going for the plan. Your help will save my day.

2
azureazure-sql-databaseazure-functionsazure-functions-runtime

2 Answers

1
votes
  1. Correct
  2. How can we know? we know nothing about your solution. if DTU is the bottleneck, it might, but setting Function to Basic app service plan is cheaper anyway.
  3. See 2
0
votes

Have you looked into azure durable functions? They can be used to circumvent the 10 minute timer. They restart when they time out but they remember their context, so if you set it up properly it's a viable solution.