Micrsoft SQL Server tempdb to instance/ephemeral disks on Amazon EC2

0

The customer having the requirement to store the Tempdb files in instance/ephemeral storage. Is there any script available to restore the tempdb drive after shutdown if we are configuring the MS SQL Server Tempdb in instance/ephemeral storage?

AWS
質問済み 4年前547ビュー
1回答
0
承認された回答

By placing tempdb on instance store the gain is twofold, not only the instance store is fast because its local to the server but also the IO against the instance store is not charged separately. Plan carefully, as you may be aware ephemeral\instance store volume is lost when the virtual machine is started on another host because ephemeral disk is locally attached to the machine

-The volume should be initialized before SQL Server service starts else the SQL Server startup procedure will fail

-The permission on the instance store volume

You may use solution from one of the below links to accomplish the same:

EBS Volumes Don't Initialize on Windows Server 2016 and Later AMIs https://docs.aws.amazon.com/AWSEC2/latest/WindowsGuide/common-issues.html#init-disks-win2k16

How to move Micrsoft SQL Server tempdb to instance/ephemeral disks on Amazon EC2 https://www.ifm.net.nz/cookbooks/amazon-sql-tempdb/index.html

AWS
エキスパート
回答済み 4年前

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

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

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

関連するコンテンツ