C:\Program Files (x86)\SQLIO>timeout /t 10 Waiting for 10 seconds, ################################################################################ # SR71-Mach2 ################################################################################ C:\Program Files (x86)\SQLIO>sqlio -kR -s60 -frandom -o32 -b8 -BN -LS -Fmach2_8thread.txt sqlio v1.5.SG using system counter for latency timings, 3385429 counts per second parameter file used: mach2_8thread.txt file 1: with 8 threads (0-7) using mask 0x0 (0) file 2: with 8 threads (8-15) using mask 0x0 (0) file 3: with 8 threads (16-23) using mask 0x0 (0) 24 threads reading for 60 secs from files 1:, 2: and 3: using 8KB random IOs enabling multiple I/Os per thread with 32 outstanding buffering set to not use file nor disk caches (as is SQL Server) using specified size: 3276800 MB for file: 1: using specified size: 3276800 MB for file: 2: using specified size: 3276800 MB for file: 3: initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 551336.16 MBs/sec: 4307.31 latency metrics: Min_Latency(ms): 0 Avg_Latency(ms): 0 Max_Latency(ms): 5 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+ %: 25 62 12 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C:\Program Files (x86)\SQLIO>timeout /t 10 Waiting for 10 seconds, ################################################################################ # Identical System Configuration with (3) 8-drive arrays of 7200 RPM SATA disks ################################################################################ C:\Program Files (x86)\SQLIO>sqlio -kR -s60 -frandom -o64 -b4 -BN -LS -Fmach2_4thread_disk.txt sqlio v1.5.SG using system counter for latency timings, 3385429 counts per second parameter file used: mach2_4thread_disk.txt file 1: with 4 threads (0-3) using mask 0x0 (0) file 2: with 4 threads (4-7) using mask 0x0 (0) file 3: with 4 threads (8-11) using mask 0x0 (0) 12 threads reading for 60 secs from files 1:, 2: and 3: using 4KB random IOs enabling multiple I/Os per thread with 64 outstanding buffering set to not use file nor disk caches (as is SQL Server) using specified size: 1000000 MB for file: 1: using specified size: 1000000 MB for file: 2: using specified size: 1000000 MB for file: 3: initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 4825.24 MBs/sec: 18.84 latency metrics: Min_Latency(ms): 1 Avg_Latency(ms): 158 Max_Latency(ms): 1754 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 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 88 C:\Program Files (x86)\SQLIO>timeout /t 60 Waiting for 60 seconds, press a key to continue ... ################################################################################ # SR71-Mach2 ################################################################################ C:\Program Files (x86)\SQLIO>sqlio -kW -s7200 -frandom -o16 -b8 -BN -LS -Fmach2_8thread.txt sqlio v1.5.SG using system counter for latency timings, 3385429 counts per second parameter file used: mach2_8thread.txt file 1: with 8 threads (0-7) using mask 0x0 (0) file 2: with 8 threads (8-15) using mask 0x0 (0) file 3: with 8 threads (16-23) using mask 0x0 (0) 24 threads writing for 7200 secs to files 1:, 2: and 3: using 8KB random IOs enabling multiple I/Os per thread with 16 outstanding buffering set to not use file nor disk caches (as is SQL Server) using specified size: 3276800 MB for raw file: 1: using specified size: 3276800 MB for raw file: 2: using specified size: 3276800 MB for raw file: 3: initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 24566.58 MBs/sec: 191.92 latency metrics: Min_Latency(ms): 0 Avg_Latency(ms): 15 Max_Latency(ms): 1190 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+ %: 36 4 3 2 2 2 2 2 3 3 4 3 3 2 2 1 1 1 1 1 1 1 1 1 18 ################################################################################ # Identical System Configuration with (3) 8-drive arrays of 7200 RPM SATA disks ################################################################################ C:\Program Files (x86)\SQLIO>sqlio -kW -s60 -frandom -o16 -b8 -BN -LS -Fmach2_8thread_disk.txt sqlio v1.5.SG using system counter for latency timings, 3385449 counts per second parameter file used: mach2_8thread_disk.txt file 1: with 8 threads (0-7) using mask 0x0 (0) file 2: with 8 threads (8-15) using mask 0x0 (0) file 3: with 8 threads (16-23) using mask 0x0 (0) 24 threads writing for 60 secs to files 1:, 2: and 3: using 8KB random IOs enabling multiple I/Os per thread with 16 outstanding buffering set to not use file nor disk caches (as is SQL Server) DeviceIoControl (DRIVE_LAYOUT) failed, error 5 using specified size: 1000000 MB for raw file: 1: DeviceIoControl (DRIVE_LAYOUT) failed, error 5 using specified size: 1000000 MB for raw file: 2: DeviceIoControl (DRIVE_LAYOUT) failed, error 5 using specified size: 1000000 MB for raw file: 3: initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 3634.97 MBs/sec: 28.39 latency metrics: Min_Latency(ms): 0 Avg_Latency(ms): 104 Max_Latency(ms): 2824 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+ %: 31 7 5 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 47