EC2 SQL Server Global Acelerator disconnect

Question

I have an EC2 instance with sql server.
I also have GlobalAcelerator pointing to that instance.

If the accelerator works quickly, I can connect from anywhere else but after a few minutes it disconnects from the SQL server.
That doesn't happen if I connect to the server without using acceleration.

How can I solve that ?

Accepted Answer

Hi, Global Accelerator has idle timeout which will close the connection if no data has been sent for a certain period.

https://docs.aws.amazon.com/global-accelerator/latest/dg/introduction-how-it-works.html#about-idle-timeout

Therefore, the solution is to send data (send some queries) to the server.

Answer

Try to increase the timeout setting and check at SQL level itself if timeout setting is properly configured there

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-query-timeout-server-configuration-option?view=sql-server-ver16

EC2 SQL Server Global Acelerator disconnect

Relevanter Inhalt