Error Code: 2011 Connection closed by SQL database

Prashant Meshram 46 Reputation points
2022-07-08T12:52:23.657+00:00

Hi Team,

I am trying to execute few procs in my azure synapse workspace using lookup and forEach loop. While few of my procs are running fine without any errors in few I am getting "The connection is closed by SQL Database." error.

I executed those procs in ssms and they seems to be running fine without any error message. Could you guys please help me out to sort this one out.

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,469 questions
Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,186 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 34,171 Reputation points MVP
    2022-07-08T13:36:56.887+00:00

    It could be related to usage limit of Azure SQL database too.

    Just for testing purpose, can you please increase the compute size of the database and run the code again?

    Also is the for each in parallel execution?

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Prashant Meshram 46 Reputation points
    2022-07-11T08:25:38.64+00:00

    Hi Team,
    Thank you for the suggestion. I tried increasing the compute size of the database. It is working fine now.
    I will be monitoring the same for few more days.

    Thank You.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.