[QUESTION] Handling "Connection is busy with results from another command"

[paxw-panevo]

Context
We are encountering an intermittent error: Connection is busy with results from another command. We could enable MARS connections, but this has some added overhead, so we are weighing other options.

Questions

1. We could attempt to handle this error by retrying. Would this be an option that folks with more experience/greater expertise recommend?

• If so, is the configuration connection_retries relevant here? I'm not sure if connection_retries (with the given description Sets the times to retry the database connection process) is only about retries on establishing the connection.

2. What are other recommendations on how to handle this intermittent error?

[danilogbotelho]

We had this problem with Express but not with the full fledged SQLServer. Which one are you using?

[paxw-panevo]

Azure SQL Server