- 新しい順
- 投票が多い順
- コメントが多い順
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