Issue with running queries on Synapse SQL Endpoint - This query cannot be executed because we can't get enough capacity for optimal performance in time.

Doug 55 Reputation points
2024-06-28T13:28:40.9133333+00:00

Dear Community,

I am getting the error ""This query cannot be executed because we can't get enough capacity for optimal performance in time."" when running a query using a SQL Serverless endpoint in Synapse Analytics

This error occurs approx. 5min after running the Query. I am running very simple queries which usually return in under 60sec.

I have been experiencing this for the past 2+ hours and it is not isolated to just myself but other Data Engineers in my team.

Could you kindly advise.

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,664 questions
{count} votes

Accepted answer
  1. Bhargava-MSFT 28,946 Reputation points Microsoft Employee
    2024-06-28T21:11:05.66+00:00

    Hello McNish, Douglas

    The product team deployed the fix, and the issue has been mitigated. You should not see these errors anymore.

    In case you still encounter any issues, please let me know.

    If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Litu Dora 0 Reputation points
    2024-07-10T10:21:07.98+00:00

    Hi Team

    I am getting the same error today on my UAT environment