EC2 SQL Server Global Acelerator disconnect

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 ?

주제

네트워킹 및 콘텐츠 전송 데이터베이스 컴퓨팅

태그

AWS Global Accelerator 마이크로소프트 SQL 서버 아마존 EC2

언어

English

Richard

질문됨 8달 전555회 조회

2개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

수락된 답변

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.

답변함 8달 전

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

Chirag Nayyar

답변함 7달 전

EC2 SQL Server Global Acelerator disconnect

관련 콘텐츠