I am trying to if confirm query timeout in Azure.

Our frontdoor is reporting a 503 response at 30 Seconds response, as its the SQL server default value, I am trying to confirm if these are indeed query command timeouts.

I've searched for "Timeout" in the Logs section of the portal monitoring (not sure this how they would be represented)

Is there an method to locate query timeouts in Azure?

Answers or links with a decent resource would be highly appreciated as my searches are not proving fruitful at the moment


Is there an method to locate query timeouts in Azure?

Here are some links:

Monitor Azure SQL Database using Azure SQL Analytics (Preview) https://docs.microsoft.com/en-us/azure/azure-monitor/insights/azure-sql

Monitoring performance by using the Query Store https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15

Extended Events in Azure SQL Database https://docs.microsoft.com/en-us/azure/sql-database/sql-database-xevent-db-diff-from-svr

| improve this answer | |

Taken from a comment:

This type of information isn't usually collected by SQL Server (or Azure SQL Database). If you don't have some sort of monitoring software then it will be hard to confirm. I would like to point you to using Extended Events, docs.microsoft.com/en-us/archive/blogs/docast/… – Jonathan Fite

| improve this answer | |

You can try using Extended Events as shown below:

 ADD EVENT sqlserver.sql_batch_completed (
 ACTION  (sqlserver.client_app_name,sqlserver.client_connection_id,sqlserver.client_hostname,sqlserver.client_pid,sqlserver.database_id,sqlserver.database_name,sqlserver.session_id,sqlserver.sql_text,sqlserver.username)
 WHERE ([result] <> (0)))
 ADD TARGET package0.asynchronous_file_target(
 SET filename='https://azureblobcontainer.blob.core.windows.net/xe-container/DemoPersistedTimeout.xel')
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.