Liam Wheldon
Liam Wheldon

Reputation: 755

AWS EC2 Volume Larger SSD or smaller volume with Provisioned IOPS

Just creating a couple new small volumes for a new SQL server's TempDB files. So I only need 2 20GB volumes but noiticed on pricing that:

But something is telling me deep down that Provisioned IOPS must surely offer something more such as a guarentee yet general purpose gives you IOPS in the range of 1500 but based on how much strain the rest of the volumes are under? Else what's the point in using the smaller volume with provisioned IOPS?

Regards Liam

Upvotes: 0

Views: 192

Answers (1)

Julio Faerman
Julio Faerman

Reputation: 13501

For some applications, "predictable performance" is more important than "high performance", and PIOPS gives you both. One should always test, but for the case case you described, GP2 SSD really seems more efficient.

You can get even more out of GP2 combining volumes using RAID/LVM. For example, 1 1TB => 3K IOPS max, 2 x 500 GB => 6K IOPS max...

Upvotes: 3

Related Questions