Share via

Azure Synapse Error: This query cannot be executed because we can't get enough capacity for optimal performance in time. This can be an intermittent issue. Please retry later.

M S 0 Reputation points
2024-08-14T08:54:19.33+00:00

I am receiving this error message since yesterday afternoon when running a Synapse Pipeline that is using SQL Serverless. The Pipeline usually runs twice a day without any issues.

[This query cannot be executed because we can't get enough capacity for optimal performance in time. This can be an intermittent issue. Please retry later.]

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,917 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bhargava-MSFT 31,011 Reputation points Microsoft Employee
    2024-08-16T16:04:29.0866667+00:00

    Hello Marion Sidler,

    PG confirmed the issue has been resolved. If you still getting the same error, I suggest you open a support ticket so that this can be further investigated by the product group.

    If you have a support plan, please go ahead and submit a ticket. If you don't have a support plan, please let me know, and I can provide a one-time free support request to address this issue.

    0 comments

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.