On Premise Data Gateway

%3CLINGO-SUB%20id%3D%22lingo-sub-2362433%22%20slang%3D%22en-US%22%3EOn%20Premise%20Data%20Gateway%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2362433%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20web%20application%20that%20calls%20some%20Logic%20App%20HTTPS%20endpoints%20to%20retrieve%20data%20from%20an%20on%20premise%20SQL%20server%20via%20the%20on-prem%20data%20gateway.%20I%20have%20noticed%20that%20when%20I%20hit%20the%20api%20first%20thing%20in%20the%20morning%20the%20initial%20call%20is%20extremely%20slow%20but%20subsequent%20calls%20are%20what%20I%20would%20expect.%20I%20dont%20see%20this%20with%20other%20endpoints%20that%20dont%20use%20a%20gateway.%20This%20leads%20me%20to%20believe%20that%20the%20gateway%20is%20%22spinning%20down%22.%20Are%20there%20any%20settings%20to%20prevent%20this%20from%20happening%20or%20do%20I%20have%20to%20create%20a%20schedule%20of%20some%20sort%20to%20call%20it%20every%20so%20often%20to%20keep%20it%20fresh.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2362433%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Gateway%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2437934%22%20slang%3D%22en-US%22%3ERe%3A%20On%20Premise%20Data%20Gateway%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2437934%22%20slang%3D%22en-US%22%3EI%20wonder%20if%20it%20is%20more%20the%20frontend%20-%20WebApp%2C%20one%20thing%20to%20check%20is%20'Always%20On'%20is%20set%20on%20the%20WebApp%2C%20as%20the%20WebApps%20unload%20after%2020%20minutes%20of%20inactivity%20to%20conserve%20resources%20by%20default.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fluke.geek.nz%2Fazure%2Fupdate-your-azure-webapp-to-be-always-on%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fluke.geek.nz%2Fazure%2Fupdate-your-azure-webapp-to-be-always-on%2F%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2581420%22%20slang%3D%22en-US%22%3ERe%3A%20On%20Premise%20Data%20Gateway%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2581420%22%20slang%3D%22en-US%22%3Ethanks%20for%20the%20reply%20but%20I%20should%20have%20clarified.%20My%20Web%20app%20that%20I%20speak%20of%20is%20a%20Vue.js%20application%20deployed%20to%20a%20storage%20account.%3C%2FLINGO-BODY%3E
Contributor

I have a web application that calls some Logic App HTTPS endpoints to retrieve data from an on premise SQL server via the on-prem data gateway. I have noticed that when I hit the api first thing in the morning the initial call is extremely slow but subsequent calls are what I would expect. I dont see this with other endpoints that dont use a gateway. This leads me to believe that the gateway is "spinning down". Are there any settings to prevent this from happening or do I have to create a schedule of some sort to call it every so often to keep it fresh. Thanks.

2 Replies
I wonder if it is more the frontend - WebApp, one thing to check is 'Always On' is set on the WebApp, as the WebApps unload after 20 minutes of inactivity to conserve resources by default.

https://luke.geek.nz/azure/update-your-azure-webapp-to-be-always-on/

thanks for the reply but I should have clarified. My Web app that I speak of is a Vue.js application deployed to a storage account. In the Logic App that provides the API endpoint...the Execute Store procedure show the delay so I'm pretty sure its the on premise gateway.