SQLIO performance tests on my SSD drive
SQLIO is a great tool to do performance tests on SANs or local hard disks. It helps you identify the optimal configurations for getting maximum data rates and latencies from your storage. Brent Ozar has created a helpful ten-minute video on how to get started with SQLIO.
I now have tested my SSD drive. To get something to relate to, I also tested my old drive in the same machine. You can see the results below.
| DiskType |
ReadOrWrite |
IOpattern |
MBs_Sec |
LatencyMS_Avg |
| SSD |
R |
random |
237 |
22 |
| NonSSD |
R |
random |
4 |
1266 |
| SSD |
R |
sequential |
250 |
22 |
| NonSSD |
R |
sequential |
38 |
155 |
| SSD |
W |
random |
65 |
96 |
| NonSSD |
W |
random |
8 |
712 |
| SSD |
W |
sequential |
95 |
60 |
| NonSSD |
W |
sequential |
38 |
161 |
The results are similar to what others report about SSD drives. The real killer is random reads, where the SSD is more than 50 times faster than the traditional drive. Also note that for SSD reading is much faster than writing, whereas for the traditional drive there is no difference in speed between reading and writing sequentially.
For more details you can see my raw output files from SQLIO here. You can also read this earlier blog post.