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


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?

asked 4 years ago650 views
1 Answer
Accepted Answer

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

answered 4 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions