Azure SQL Database
An Azure relational database service.
3,813 questions
Why are SQL Database services in West Europe running so slowly and there are not enough resources to scale?
Laurence Mee
156
Reputation points
I'm trying to scale a SQL Database and I keep getting told that there are not enough resources.
It takes minutes, literally, to view any database in the Azure Portal (other services are quick).
Queries are all running slowly.
What is going on?
{count} votes
-
Oury Ba-MSFT 11,371 Reputation points Microsoft Employee2023-05-16T18:44:37.5366667+00:00 Laurence Mee Thank you for reaching out.
I am sorry to have that you are facing issues scaling database in West Europe region.
How many minutes it approximately took to scale it.? or it did not scale at all. Could you please the full error message.
what is the service tier.
From which service tier are you trying to scale from?
Regards,
Oury
-
Laurence Mee 156 Reputation points
2023-05-16T23:49:48.2033333+00:00 I have since been able to scale. The error was that it was out of resources and I should try again later. This was for most of the afternoon. It was taking minutes just to open the database overview in the Azure Portal.
-
Laurence Mee 156 Reputation points
2023-05-16T23:50:10.6933333+00:00 Going from Basic to Standard S0 5GB.
-
Laurence Mee 156 Reputation points
2023-05-16T23:51:33.4233333+00:00 It seems to me that there was a resource issue for SQL in West Europe that went un-reported, again.
-
Oury Ba-MSFT 11,371 Reputation points Microsoft Employee
2023-05-18T19:41:09.02+00:00 Sorry about this issue. I am glad you were able to scale your DB successfully. I will advise you if it happens again to open a new thread in reference to this one and I will help you route this to the CSS team to troubleshoot with proper tool.
Regards,
Oury
-
David S 0 Reputation points
2023-05-22T21:18:11.0933333+00:00 I can provide some general insights into possible reasons why SQL Database services in a particular region, such as West Europe, may experience slow performance and insufficient resources for scaling:
High demand: If there is a high demand for SQL Database services in the West Europe region, it can put a strain on the available resources, leading to slower performance. This can occur when there is a large number of users or applications simultaneously accessing and querying the databases.
Infrastructure issues: Slow performance can also be caused by infrastructure issues within the data center or network that supports the SQL Database services. Problems like network congestion, hardware failures, or insufficient capacity can impact the overall performance.
Resource allocation: If there is inadequate resource allocation or management, it can limit the ability to scale up resources effectively. Insufficient computing power, memory, or storage capacity can restrict the performance and scalability of SQL Database services.
Software optimizations: Database management systems (DBMS) require constant optimizations to ensure efficient query execution and resource utilization. If the SQL Database services in West Europe are not optimized properly or are running outdated software versions, it can result in slower performance.
Temporary issues or maintenance: Occasionally, slowdowns in SQL Database services can occur due to temporary issues or scheduled maintenance activities. These situations can affect performance until the underlying problems are resolved or maintenance is completed.
To address these issues, it's recommended to reach out to the specific SQL Database service provider's support or operations team. They can provide up-to-date information about the status of their services in the West Europe region and assist in resolving any performance or scaling concerns you may have.
-
David S 0 Reputation points
2023-05-22T21:21:21.3266667+00:00 Thanks
-
Oury Ba-MSFT 11,371 Reputation points Microsoft Employee
2023-05-25T00:03:15.78+00:00 Laurence Mee Could you please send an email to azcommunity@microsoft.com and share your subscription ID, database name, server name. Please don't forget to mention in the subject line ATTN: Oury so I don't miss it.
Regards,
Oury
Sign in to comment