Share via

Azure SQL Database - 7200 Timeout

jase jackson USA 201 Reputation points
2021-01-24T15:16:55.32+00:00

Is there a method/configurable option where a Azure SQL Database Stored Procedure can be called (i.e. from HTTP Post - Logic App) and it not suffer from the azure sql dbase 7200 limit? The stored procedure includes a number of "child" procedures and the overall time is approx 6 hours?

Data Factory could possibly be used but time and cost is incurred whilst waiting for the Store Procedure to complete; so therefore does not seem a good use of spend. Also the database has been scaled; doing more is not an option due to the relatively high cost.

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-01-26T02:03:31.173+00:00

    @jase jackson USA

    if scaling is not an option, Please check this document for tuning your queries to make DB and queries more efficient.

    Another option is to use Azure Automation Runbook as described on Stack Overflow post here.

    Please check and get back to us for more questions.

    Regards
    Navtej S

    Was this answer helpful?

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.