Forum Discussion
Intermittent connectivity issues connecting to lakehouse SQL Analytics endpoint
Hi gmangiante,
According to your description, it seems like more related azure app service release resource which connections used to optimize/reduce the source usage.
Have you tried to add some simply query to request with low frequency as heartbeat to keep connections alive?Regards,
Xiaoxin Sheng
Hi gmangiante,
According to your description, it seems like more related azure app service release resource which connections used to optimize/reduce the source usage.
Have you tried to add some simply query to request with low frequency as heartbeat to keep connections alive?
Regards,
Xiaoxin Sheng
Hi, Xiaoxin - thanks so much for the timely reply, and I think it's a great suggestion. Will give that a shot!
Hi gmangiante,
I think I find the document that mentions this at the azure app service performance Q&A:
Application performance FAQs - Azure | Microsoft Learn
Azure Load Balancer has a default idle timeout setting of four minutes. This setting is generally a reasonable response time limit for a web request. so, App Service returns a timeout to the client if your application does not return a response within approximately 240 seconds (230 seconds on Windows app, 240 seconds on Linux app). If your web app requires background processing, we recommend using Azure WebJobs. The Azure web app can call WebJobs and be notified when background processing is finished. You can choose from multiple methods for using WebJobs, including queues and triggers.
For this scenario, you can add the processing in code, use background processing in webJob or manually modify the timeout properties.
Regards,
Xiaoxin Sheng