Slow access from other EC2 servers after stop and start of EC2 instance

0

Our setup consists of a primary "server" c3.xlarge that includes SQL Server 2014 on Windows Server 2012 R2. There are client apps connecting to SQL Server from two other EC2 instances (t2.small) - let's call these "clients". Things worked fine until AWS sent a broadcast messages about underlying hardware degradation and mandated the "server" c3.xlarge be stopped and started, essentially moving it to a different physical host. From then on, performance of the client app became abysmal. Round trips to SQL Server to get data can take 500ms now where it used to take 10ms. SQL Server Profiler running on the "server" shows normal processing times, but we can see the StartTime of the next query in a sequence being 500ms from the EndTime of the one prior. To attempt to remedy the issue, one of the "client" instances was changed to "c5a.large", but it is still about 10x slower than before the "server" was stop-started.

Any thoughts? Is there a setting missing somewhere to put all 3 EC2 instances on the same physical host, if that is even possible?

已提問 7 個月前檢視次數 239 次
1 個回答
0

With regards to be able to place 3 EC2 instances on the same physical host, you may want to explorer AWS Placement Groups. There are three categories of placement groups, you can refer to the below link https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/placement-groups.html

-Neeraj

profile picture
已回答 7 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南