|
 |
|
The real benefit of SSDs for applications involves latency for small block I/O requests. While the fastest 2.5-inch 15K RPM drive might be able to do 250 random IOPS, most enterprise SSDs should be able to easily sustain 40,000 IOPS for read and 30,000 IOPS for write in today's world. Of course, you need to have the hardware to achieve this performance, and that will be discussed in part 2 of this series.
|
|
There are obvious parts of heavily used databases that can benefit from SSD technology, and the most obvious are database indexes. The second most obvious part of databases that can benefit from SSDs are database logs files. Both of these are generally smaller than the table space and are often placed on 15K RPM disk drives today, and even then are still frequently limited in performance. Performance tools such as iostat, sar and other performance monitoring tools are often used to evaluate the high latency found on storage attached to the LUNs associated with these devices.
As flash storage is still extremely expensive compared to spinning disk, it is critical to understand the potential benefits from flash. If you have large command queues on the device and high latency per command (something over a quarter of a second), then flash storage might be the answer for your database.
There are obvious parts of heavily used databases that can benefit from SSD technology, and the most obvious are database indexes. The second most obvious part of databases that can benefit from SSDs are database logs files. Both of these are generally smaller than the table space and are often placed on 15K RPM disk drives today, and even then are still frequently limited in performance. |
|
|
|