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
