Synapse- The timeout period elapsed prior to completion of the operation or the server is not Responding

Prabhat Rawat 1 Reputation point
2021-12-14T14:05:18.193+00:00

Hi
I am seeing this timeout error when running a stored procedure on the Synapse Dedicated SQL pool exactly after 2 hrs i kickoff the query. I'm unable to find any way to resolve it or the root cause of the problem.

Kindly help me with that
Thanks,
Prabhat

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.
4,119 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Armando Lacerda 11 Reputation points MVP
    2021-12-30T17:36:59.65+00:00

    Synapse Studio (browser-based interface) is not the best place to execute a long running query. You know ... you close the browser by mistake and the query aborts. Deferred compute options are preferred here. For instance, having a Synapse Pipeline and run the stored procedure from it would do the trick, with a few cents of a US dollar cost added to it.

    With that said, I am not aware of any setting in the studio itself for query timeout. @Prabhat Rawat , I would recommend using either SSMS or ADS.

    0 comments No comments