Close

October 21, 2012

Re-visiting SQLIO SSD Disk Performance Tests

Below are test results from re-running SQLIO tests on a laptop workstation used primariyl for Microsoft SQL Server 2008 R2/2012

SQLIO is a tool provided by Microsoft which can also be used to determine the I/O capacity of a given configuration.   Click here for the software. Test configurations were based on Brent Ozars article on finding SAN bottlenecks. Click here for the article.

Test was run with a 1Gb test file.

Results:

Write/Random:

CUMULATIVE DATA:
throughput metrics:
IOs/sec: 27918.74
MBs/sec: 218.11
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 1
Max_Latency(ms): 1573
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+
%: 1 36 57 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Read/Random

CUMULATIVE DATA:
throughput metrics:
IOs/sec: 22417.17
MBs/sec: 175.13
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 65
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+
%: 1 17 44 28 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Write/Sequential:

CUMULATIVE DATA:
throughput metrics:
IOs/sec: 4079.34
MBs/sec: 254.95
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 15
Max_Latency(ms): 3949
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 99 0 0 0 0 0 0 0 0 0

Read/Sequential

CUMULATIVE DATA:
throughput metrics:
IOs/sec: 4266.00
MBs/sec: 266.62
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 14
Max_Latency(ms): 6629
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 1 2 1 57 40 0 0 0 0 0 0 0 0 0