0

I recently set up some analytics for my Azure SQL DB, using Azure SQL Analytics. (https://learn.microsoft.com/en-us/azure/azure-monitor/insights/azure-sql)

One of the metrics that is measured is Timeouts. I have logging in my application, and I'm not seeing any blocking or deadlocks, and I don't see anything where a query is actually failing.

My question is this -- what is considered a Timeout?

As a bonus question, most of the time I'm seeing four timeouts together. This is a node.js application, and I use a tedious driver to interact with the database. Is there something in tedious where it is retrying the queries four times, etc.?

ADeveloper
  • 1
  • 1
  • 1

1 Answers1

1

Connection timeouts occur because the application can't connect to the server. A possible reason may be the max number of milliseconds period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections.

Azure SQL Database will close idle connections of more than 30 minutes. Excerpt: "For example, if you are connected to your database through SQL Server Management Studio for longer than 30 minutes without having any active request your session will timeout and because there are no active requests SQL Azure can’t return an error". Source is here.

When trying connections to Azure SQL Database you need a retry logic. My suggestion is use tedious connection pool since the pool retry connections.

Set the retryDelay parameter. This parameter is the number of milliseconds to wait after a connection fails, before trying again. Default = 5000.

The idleTimeout parameter is the number of milliseconds before closing an unused connection. Default = 300000 which is enough for Azure SQL connections.

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30
  • Thank you, Alberto. We do use tedious for our connection pool. My question is -- what is a timeout? – ADeveloper Mar 28 '20 at 02:17
  • I do not believe this is a connection timeout. I can see the query that was executed. How would I be able to do that if it never connected? – ADeveloper Mar 30 '20 at 13:34
  • Azure SQL DB closes idle connections after some time. Please read https://azure.microsoft.com/en-us/blog/connections-and-sql-azure/ this will cause a timeout. I updated my answer again. – Alberto Morillo Mar 30 '20 at 14:04