EC2 SQL Server Global Acelerator disconnect

0

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 ?

2回答
0
承認された回答

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.

profile picture
HS
回答済み 7ヶ月前
0

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

profile picture
回答済み 7ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ