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ヶ月前

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

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

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

関連するコンテンツ