Blog Post

Azure Database Support Blog
4 MIN READ

Azure SQL Database idle sessions are killed after about 30 minutes when "Proxy" connection policy

hugo_sql's avatar
hugo_sql
Icon for Microsoft rankMicrosoft
Sep 29, 2022
When we connect to our Azure SQL Databases or Azure SQL Managed Instances databases using the "Proxy" connection policy and the session is still open without any activity, the Azure SQL Gateway will ...
Updated Mar 18, 2024
Version 4.0
azure
databases
idle
kill
Managed Instance
sessions
sql
subbuk's avatar
subbuk
Icon for Microsoft rankMicrosoft
Oct 04, 2022

Idle connections can get killed at the TCP Layer or by the Gateway.  

  • If idle at the TCP layer, connections can be dropped by network at client side and will have nothing to do with Gateway. 
  • And if it's idle by the Gateway where TCP keepalive messages might be occurring, but not had an active query in 30 minutes, then Gateway will determine that the TDS connection is idle and terminates the connection.