question

KundanChaulya-1586 avatar image
1 Vote"
KundanChaulya-1586 asked ·

Frequent service health issue for Azure SQL DB

We are encountering frequent service health issues for Azure SQL DB in one of our test subscription. We are getting the below service health issue.

“We're sorry your SQL database is unavailable at this time. Currently, Azure shows the downtime for your SQL database resource at a two-minute granularity. The actual downtime is likely less than a minute – average is 2s. We're working to determine the source of the problem.”

8840-healthissue-events.png
Currently, this DB is getting accessed using private link. We are not able to figure out the reason for the same. Does anybody have an idea of what the problem could be?


azure-sql-database
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

pituach avatar image
0 Votes"
pituach answered ·

Good day Kundan.

sorry your SQL database is unavailable at this time. Currently, Azure shows the downtime for your SQL database resource at a two-minute granularity. The actual downtime is likely less than a minute

In order to understand the issue we need more information.

1) always compare your log to the history of known issues

https://status.azure.com/en-us/status/history/

2) Let's start with the service tier that you are using, since I have a feeling that you are using "Azure SQL Database serverless", which make this report perfectly understandable.

Azure SQL Database serverless pause the service and it can take up to a minute to resume the service. This means that if for example you have a website which is not so active then you might have X time without any activity and the Azure Engine pause the service. First user which come to the website after the database was paused, will "wake up" the system and will need about a minute ton get the respond from the server. This might lead to time out.

3) Please review the following document on handling errors: Working with SQL Database connection issues and transient errors.

In the meantime what can you do?


Recommended in most cases to implement a "retry logic" to handle the intermittent issues. You can use geo-replication for regional issues. If you are having an issue with specific service (database) then you should create an Azure Support Request, so the team will be able to examine your specific service.





· 2 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

We have checked the status history and don't think this due to any reported service issue. We are encountering this issue from 19-May-2020 consistently almost every day. We are using "General Purpose: Gen5, 8 vCores" as a pricing tier. Please let me know if any other info will help us to find the root cause.

0 Votes 0 ·
pituach avatar image pituach KundanChaulya-1586 ·

Hi,

We are using "General Purpose: Gen5, 8 vCores"

This does not means that you are not using serverless version :-)

using this configuration you still have two Compute tier which you can select

8866-f.png


0 Votes 0 ·
f.png (30.7 KiB)
KundanChaulya-1586 avatar image
0 Votes"
KundanChaulya-1586 answered ·


My apologies, I was not very clear. We are not using serverless. Please refer to the DB config below.

8867-db-config.png




db-config.png (71.1 KiB)
· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @KundanChaulya-1586

Can you please detail what the specific health events are or are they all that same issue? For example, yesterday for June 1st there were 3 health events. What are those specific events?

If they are all the same message?


There are a couple options. The first is to go through the following document and leverage the DMV queries to identify what aspect of your service is experiencing issues. Check for CPU, memory, or IO issues, etc.

Monitoring Microsoft Azure SQL Database and Azure SQL Managed Instance performance using dynamic management views

The second option to create a support request.


0 Votes 0 ·
KundanChaulya-1586 avatar image
1 Vote"
KundanChaulya-1586 answered ·

Thank you @Zagato36 and @pituach for looking into the issue and suggesting option to find the root cause. We had created a support request and we have been told that its due to Azure service itself. The last update received on 8-June-2020 where its mentioned that Product engineering team has applied a fix for the issue. I will update here once we get the detailed RCA.


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.