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?
- 最新
- 投票最多
- 评论最多
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
