Cant launch a SQL Endpoint

Question

I am trying to create a new SQL point. I have chosen an X-small cluster size and it is 'failing to start' with this error:

Clusters are failing to launch. Cluster launch will be retried. Details for the latest failure:
Error: Error code: QuotaExceeded, error message: Operation could not be completed as it results in exceeding approved LowPriorityCores quota. Additional details - Deployment Model: Resource Manager, Location: ukwest, Current Limit: 6, Current Usage: 0, Additional Required: 8, (Minimum) New Limit Required: 8. Submit a request for Quota increase at https://aka.ms/ProdportalCRP/#blade/Microsoft_Azure_Capacity/UsageAndQuota.ReactView/Parameters/%7B%22subscriptionId%22:%223aa8e972-80dd-42b4-b4a1-32f6ce8f5f5b%22,%22command%22:%22openQuotaApprovalBlade%22,%22quotas%22:[%7B%22location%22:%22ukwest%22,%22providerId%22:%22Microsoft.Compute%22,%22resourceName%22:%22lowPriorityCores%22,%22quotaRequest%22:%7B%22properties%22:%7B%22limit%22:8,%22unit%22:%22Count%22,%22name%22:%7B%22value%22:%22lowPriorityCores%22%7D%7D%7D%7D]%7D by specifying parameters listed in the ‘Details’ section for deployment to succeed. Please read more about quota limits at https://learn.microsoft.com/en-us/azure/azure-portal/supportability/low-priority-quota
Type: CLIENT_ERROR
Code: AZURE_QUOTA_EXCEEDED_EXCEPTION
Cluster-id (internal): 0205-162657-r6p37nct
Additional details: {"azure_error_code":"QuotaExceeded","azure_error_message":"Operation could not be completed as it results in exceeding approved LowPriorityCores quota. Additional details - Deployment Model: Resource Manager, Location: ukwest, Current Limit: 6, Current Usage: 0, Additional Required: 8, (Minimum) New Limit Required: 8. Submit a request for Quota increase at https://aka.ms/ProdportalCRP/#blade/Microsoft_Azure_Capacity/UsageAndQuota.ReactView/Parameters/%7B%22subscriptionId%22:%223aa8e972-80dd-42b4-b4a1-32f6ce8f5f5b%22,%22command%22:%22openQuotaApprovalBlade%22,%22quotas%22:[%7B%22location%22:%22ukwest%22,%22providerId%22:%22Microsoft.Compute%22,%22resourceName%22:%22lowPriorityCores%22,%22quotaRequest%22:%7B%22properties%22:%7B%22limit%22:8,%22unit%22:%22Count%22,%22name%22:%7B%22value%22:%22lowPriorityCores%22%7D%7D%7D%7D]%7D by specifying parameters listed in the ‘Details’ section for deployment to succeed. Please read more about quota limits at https://learn.microsoft.com/en-us/azure/azure-portal/supportability/low-priority-quota"}

I have a student subscription, and when I go to Usage+quotas I can see 'Usage at or near quota' for
Network Watchers 100%.

Have I run out of some quota and what I can do about it? this is the first endpoint I have tried to create in order to follow a Databricks tutorial.

Answer

Hello @Maria ,

Thanks for the question and using MS Q&A platform.

As per my understanding, seems like you are trying to create/launch SQL Endpoints in Azure Databricks, but you are receiving above error related to quota limits. Please correct if I'm not accurate.

From the error message it seems like you having LowPriorityCores quota approved.

In order to create SQL endpoint, you must have adequate vCPU quota in your Azure account. The default vCPU quota is usually adequate to create the starter endpoint that is created automatically on new workspaces. However, your Azure account may not have adequate vCPU quota to scale the starter endpoint or to create additional endpoints. Your Azure account may have limitations on how much vCPU quota you can request.

To resolve this issue, we recommend contacting your Azure account representative for requesting additional vCPU quota as described in this doc: Request additional vCPU quota.

Your request will be reviewed, and you'll be notified whether the request is approved or rejected. This usually happens within a few minutes. If your request is rejected, you'll see a link where you can open a support request so that a support engineer can assist you with the increase.

If your request to increase your VM-family quota is approved, Azure will automatically increase the regional vCPU quota for the region where your VM is deployed.

Related helpful docs:

Please work with your Azure account administration or reach out to support as explained in the documents provided above.

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

Cant launch a SQL Endpoint

1 answer