Is there an outage in UK South affecting Azure Synapse Analytics?

Question

At around 10am (BST), our Azure Synapse Analytics pipelines started failing with the following error message:

Operation on target Copy data failed: Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following 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.]

Statement ID: {A3222557-9848-4329-B49B-3250AFCF4A65} | Query hash: 0x60A39422D3E24000 | Distributed request ID: {30D57CD9-66B0-4310-AAC4-B5C0C349BF1A}. Total size of data scanned is 0 megabytes, total size of data moved is 0 megabytes, total size of data written is 0 megabytes.',Source=,''Type=System.Data.SqlClient.SqlException,Message=[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.]

Statement ID: {A3222557-9848-4329-B49B-3250AFCF4A65} | Query hash: 0x60A39422D3E24000 | Distributed request ID: {30D57CD9-66B0-4310-AAC4-B5C0C349BF1A}. Total size of data scanned is 0 megabytes, total size of data moved is 0 megabytes, total size of data written is 0 megabytes.,Source=.Net SqlClient Data Provider,SqlErrorNumber=70001,Class=17,ErrorCode=-2146232060,State=1,Errors=[{Class=17,Number=70001,State=1,Message=[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.],},{Class=0,Number=15885,State=1,Message=Statement ID: {A3222557-9848-4329-B49B-3250AFCF4A65} | Query hash: 0x60A39422D3E24000 | Distributed request ID: {30D57CD9-66B0-4310-AAC4-B5C0C349BF1A}. Total size of data scanned is 0 megabytes, total size of data moved is 0 megabytes, total size of data written is 0 megabytes.,},],'

Also, we are receiving the following error message when running a simple 'SELECT TOP (1000)' query against all of our serverless SQL environments:

Msg 70001, Level 17, State 1, Line 2 [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.]

Is this likely a Microsoft UK South outage issue or a problem with our own resources?

Thank you

Answer 1

Hello James Neville,

I checked with my internal team and confirmed that this issue was due to an outage in the UK South region.

The issue has been mitigated now, and you should not see these errors anymore.

Root cause: Due to high demand for SQL pools in the UK South region, we were unable to serve all customer requests during this time interval.

The Synapse team is improving monitoring logic to handle these situations proactively and providing more physical capacity in this region to manage high demand. We apologize for any inconvenience this may have caused.

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