RSS

The beauty of SSD

05 Jan

No more grinding and waiting for me, just the humm of 4 fans to keep me company.

Here are some SQLIO results from a test on my new SSD which is an OCZ vertex 2. The first test uses small 4KB disk requests to see how many IOPS I can get and the second uses larger 256KB IOs to see the top bandwidth.

C:UsersnujakDesktopSQLIO_old>sqlio -kW -t24 -s30 -o20 -fsequential -b4 -BH -LS -F1file1lun1th.txt
sqlio v1.5.SG
using system counter for latency timings, 2740654 counts per second
parameter file used: 1file1lun1th.txt
file C:testfile.dat with 1 thread (0) using mask 0x0 (0)
1 thread writing for 30 secs to file C:testfile.dat
using 4KB sequential IOs
enabling multiple I/Os per thread with 20 outstanding
buffering set to use hardware disk cache (but not file cache)
using specified size: 10240 MB for file: C:testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 24246.70
MBs/sec: 94.71
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 47
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

C:UsersnujakDesktopSQLIO_old>sqlio -kR -t24 -s30 -o20 -fsequential -b256 -BH -LS -F1file1lun1th.txt
sqlio v1.5.SG
using system counter for latency timings, 2740654 counts per second
parameter file used: 1file1lun1th.txt
file C:testfile.dat with 1 thread (0) using mask 0x0 (0)
1 thread reading for 30 secs from file C:testfile.dat
using 256KB sequential IOs
enabling multiple I/Os per thread with 20 outstanding
buffering set to use hardware disk cache (but not file cache)
using specified size: 10240 MB for file: C:testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 902.40
MBs/sec: 225.60
latency metrics:
Min_Latency(ms): 21
Avg_Latency(ms): 21
Max_Latency(ms): 55
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 36 61 0 3

225MBs/sec and 24,000 IOPS are two awesome numbers and I got it all in near silence. The SSD is gaining ground each year but the HDD or spinning platter based disk storage still common. The drive is advertised at 285/40,000 but I’d say for a few minutes of testing i’m satisfied with the results.

When buying disk you should evaluate by cost/per GB and cost/per MB/sec. I picked mine up for about $190 so my cost/gb = $1.58 and my cost per MB/s = $0.84

Instead of the 120GB option I considered getting two 60GB drives and striping them. I decided not to because I couldn’t justify the cost with the already massive performance jump I was taking. This drive is also rated 7.4 on a scale of 1.0 to 7.9 on the Windows Experience Index.

Advertisements
 
Leave a comment

Posted by on January 5, 2011 in Network Admin

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: