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 年前檢視次數 548 次
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 年前

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

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

回答問題指南