Lesson Learned #214: Hands-On-Labs: How to manage an idle connection state issue

This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .

We used to have cases where our customers leave the connection open without any activity, as you could see in this URL we are going to explain why the connection is dropped due to an idle connection state issue.


Why this connection is dropped?


  • Idle at the TCP layer, where connections can be dropped by any number of network devices.
  • Idle by the Azure SQL Gateway, after no activity after 30 mins.


How to find?

  • Multiple error message depending on if the driver is ODBC, .NET or JDBC.


How to Fix?


In this video we will cover scenarios causing this error using C# and Java with Hikari connection pooler.




Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.