How come I can no longer put in a support ticket via Azure? It takes me here now.

Question

Resource ID : 1. The request limit for the database is 60 and has been reached. See 'https://docs.microsoft.com/azure/azure-sql/database/resource-limits-logical-server' for assistance. (Framework Microsoft SqlClient Data Provider)

Answer 1

Hi Greg,

In regards to the error you are seeing, each service tier has a maximum concurrent workers limit. The error says "request limit" for backward compatibility reasons. Max concurrent workers is applicable limit.

To increase the limit you would need to upgrade to a higher tier. For example, if you are currently on Standard with 10 DTUs (S0) you could increase the limit to 90 by moving to 20 DTUs (S1).

To increase to 20 DTUs you would navigate to your SQL Database in the portal, next click Settings -- Compute + storage blade, moving the DTU slider to 20, and click Apply.

Below is screenshot from documentation page showing max concurrent workers limitation for single server DTU:

If you are on tier different than DTU 10, the same principle applies—you need to upgrade to higher tier.

An alternative to moving to higher tier would be to make changes to your application code/design to reduce the number of concurrent connections being used.

In regards to support ticket, if you have Developer level support plan this is the correct place for your question. Standard plan and higher allows you to submit ticket via Azure portal.

https://learn.microsoft.com/en-us/azure/azure-portal/supportability/priority-community-support

Please let me know if the above is clear and/or if you have questions.

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP