Azure SQL Database - Transient Errors

jase jackson USA 201 Reputation points
2021-03-08T11:40:50.66+00:00

We have a relatively simple scenario where Logic App (la) executes a azure sql database stored procedure (which executes a number of sub procedures). However we have an issue where the store procedure ends without error which I assume is related to "transient errors'. I've assumed this whilst there are also "time out" logs at the same time as the "disconnection". The procedure has successfully executed for years. The point at which it ends differs each time and is not at a stage which is resource heavy/intensive.

1) we have logging for errors/time outs but there is no log of a disconnection "drop out"

2) Is there a best practice approach to manage such a scenario. Clearly the connection has been lost so the stored procedure cannot handle the issue. Assume we could use the logic app to check after a period of time and if a condition is not met try again? Just wanted to check if there is an advised/official more robust approach to handle the scenario.

We have not used ADF for the processing of the stored procedures due to the cost as it has to process and wait for a significant number of procedures to execute (the process can take a number of hours to complete)

Thanks

Azure SQL Database
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,938 questions
{count} votes

Accepted answer
  1. jase jackson USA 201 Reputation points
    2021-03-15T16:55:12.66+00:00

    We have rebuilt the table and the performance is now 1 second again. I assume this performance degradation was caused by fragmentation of the table? I'll close the question.


0 additional answers

Sort by: Most helpful