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.

Question

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

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.]

Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2024-08-14T17:43:30.4266667+00:00

Hello Marion Sidler,

Could you let us know your synapse region?

This morning, there was an issue in the West Europe region, however it has been mitigated now.
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2024-08-15T18:49:33.0833333+00:00

Hello Marion Sidler,

I am checking to see if you are still encountering the same error
M S 0 Reputation points

2024-08-16T04:32:02.26+00:00

Hi @Bhargava-MSFT

We're in the West Europe region and are still getting the same error.
M S 0 Reputation points

2024-08-16T05:00:15.4466667+00:00

Hello @Bhargava-MSFT

We're in the West Europe region and are still getting the same error.
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2024-08-23T17:35:44.2266667+00:00

Hello M S,

I am checking to see if you need any further assistance from my end.

1 answer

Your answer

Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2024-08-14T17:43:30.4266667+00:00

Hello Marion Sidler,

Could you let us know your synapse region?

This morning, there was an issue in the West Europe region, however it has been mitigated now.
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2024-08-15T18:49:33.0833333+00:00

Hello Marion Sidler,

I am checking to see if you are still encountering the same error
M S 0 Reputation points

2024-08-16T04:32:02.26+00:00

Hi @Bhargava-MSFT

We're in the West Europe region and are still getting the same error.
M S 0 Reputation points

2024-08-16T05:00:15.4466667+00:00

Hello @Bhargava-MSFT

We're in the West Europe region and are still getting the same error.
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2024-08-23T17:35:44.2266667+00:00

Hello M S,

I am checking to see if you need any further assistance from my end.

Answer 1

Bhargava-MSFT 31,361 Microsoft Employee Moderator

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

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.

1 answer

Your answer