All Synapse Serverless Pool queries are failing as of today. Global Issue?

Question

I am getting the following error on all queries
"This query cannot be executed due to current resource constraints"

Is there a global issue?

Answer 1

Hi @Derek Horrall ,

Thankyou for using Microsoft Q&A platform and thanks for posting your question.

As I understand your query here, you are facing issue while trying to run queries in Serverless SQL pool and the error you are getting is : "This query cannot be executed due to current resource constraints"

If your query fails with the error message 'This query can't be executed due to current resource constraints', it means that serverless SQL pool isn't able to execute it at this moment due to resource constraints:

• Make sure data types of reasonable sizes are used.
• If your query targets Parquet files, consider defining explicit types for string columns because they'll be VARCHAR(8000) by default. Check inferred data types.
• If your query targets CSV files, consider creating statistics.
• Visit performance best practices for serverless SQL pool to optimize query.

For more details, Please refer to the following article: Query fails because it cannot be executed due to current resource constraints

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators