Quote Originally Posted by Dave_O View Post
I installed SQL IO on my SIMS server (virtual) and ran 4 tests - sequential read & write and random read & write over a 30 second period. The results are below. I would be interested in the results of others running the same commands (also given below):-

sqlio -kR -s30 -frandom -o8 -b8 -LS -Fparam.txt
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 34867.99
MBs/sec: 272.40
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 98
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+
%: 99 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

sqlio -kW -s30 -frandom -o8 -b8 -LS -Fparam.txt
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 34123.80
MBs/sec: 266.59
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 84
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+
%: 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

sqlio -kR -s30 -fsequential -o8 -b8 -LS -Fparam.txt
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 36841.62
MBs/sec: 287.82
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 23
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+
%: 99 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

sqlio -kW -s30 -fsequential -o8 -b8 -LS -Fparam.txt
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 10728.56
MBs/sec: 83.81
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 52
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+
%: 85 0 0 0 2 3 2 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
It's just over a year since I posted this. Has anyone else done this test? I would be interested in seeing the results both from a physical and virtual SIMS instance