Blog Post

Azure Database Support Blog
2 MIN READ

Lesson Learned #180: Creating a retry-logic for TSQL command execution.

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Dec 28, 2021
As you know, one of the recommendations that we have in Azure SQL Database is to have a connection retry-logic, however, I would like to share with you other recommendation for command execution.  ...
Updated Dec 28, 2021
Version 2.0
DaveDustin's avatar
DaveDustin
Copper Contributor
Dec 28, 2021

Nice clean example code.

Have you considered using an exponential backoff or random variation on the retry interval?

Using a fixed period can lead to increased pressure, especially on a highly concurrent system, where you could have thousands of connections attempting to retry all at the same time.