Setup is as follows

VNX5300

2 x 9+1, 600GB 15K SAS configured in RAID Groups

1 x 9+1 600GB 15K SAS + 6+2 2TB SATA in Storage Pool

2 x 200GB SSD configured as Fast Cache

3 ESX hosts connected via 4GB FC (SAN is currently on 4GB FC as well)

SQL VM running Windows 2008 R2

4 vCPU

16GB RAM

40GB OS partition

3 x RDMs for User DBs, Logs and System DBs

Pathing Policy set to Round Robin

This server isn't in production yet but we ran SQLIO on it to benchmark it and we're fairly disappointed with the results. I would have thought with the EFDs the performance would be flying but apparently not. Any thoughts? Our DBA ran the SQLIO so I need to double check his configuration but here's the output from some of SQLIO.

Oxpdvsql02 Datadrive - Random

C:\Program Files (x86)\SQLIO>sqlio -kW -t8 -s900 -o8 -frandom -b64 -BH -LS -Fpa

1. am.txt

sqlio v1.5.SG

using system counter for latency timings, 14318180 counts per second

parameter file used: param.txt

        file g:\testfile.dat with 2 threads (0-1) using mask 0x0 (0)

2 threads writing for 900 secs to file g:\testfile.dat

        using 64KB random IOs

        enabling multiple I/Os per thread with 8 outstanding

        buffering set to use hardware disk cache (but not file cache)

size of file g:\testfile.dat needs to be: 83886080000 bytes

current file size:      0 bytes

need to expand by:      83886080000 bytes

expanding g:\testfile.dat ... done.

using specified size: 80000 MB for file: g:\testfile.dat

initialization done

CUMULATIVE DATA:

throughput metrics:

IOs/sec:  1297.80

MBs/sec:    81.11

latency metrics:

Min_Latency(ms): 0

Avg_Latency(ms): 11

Max_Latency(ms): 559

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  2  1  0  0 1  2  5  8 12 14 15 12  9  6  4  2 1  1  0  0  0  0  1

Oxpdvsql02 Log files -sequential

C:\Program Files (x86)\SQLIO>sqlio -kW -t2 -s900 -o8 -fsequential -b64 -BH -LS

1. Fparam.txt

sqlio v1.5.SG

using system counter for latency timings, 14318180 counts per second

parameter file used: param.txt

        file H:\testfile.dat with 2 threads (0-1) using mask 0x0 (0)

2 threads writing for 900 secs to file H:\testfile.dat

        using 64KB sequential IOs

        enabling multiple I/Os per thread with 8 outstanding

        buffering set to use hardware disk cache (but not file cache)

size of file H:\testfile.dat needs to be: 83886080000 bytes

current file size:      0 bytes

need to expand by:      83886080000 bytes

expanding H:\testfile.dat ... done.

using specified size: 80000 MB for file: H:\testfile.dat

initialization done

CUMULATIVE DATA:

throughput metrics:

IOs/sec:  3473.37

MBs/sec:   217.08

latency metrics:

Min_Latency(ms): 0

Avg_Latency(ms): 4

Max_Latency(ms): 92

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  6 46 12  8  6  5  4 3  2  2  1  1  1  1  0  0 0  0  0  0  0  0  0  1

Oxpdvsql02 Tempdb - random

C:\Program Files (x86)\SQLIO>sqlio -kW -t8 -s900 -o8 -frandom -b64 -BH -LS -Fparam.txt

sqlio v1.5.SG

using system counter for latency timings, 14318180 counts per second

parameter file used: param.txt

        file i:\testfile.dat with 2 threads (0-1) using mask 0x0 (0)

2 threads writing for 900 secs to file i:\testfile.dat

        using 64KB random IOs

        enabling multiple I/Os per thread with 8 outstanding

        buffering set to use hardware disk cache (but not file cache)

size of file i:\testfile.dat needs to be: 83886080000 bytes

current file size:      0 bytes

need to expand by:      83886080000 bytes

expanding i:\testfile.dat ... done.

using specified size: 80000 MB for file: i:\testfile.dat

initialization done

CUMULATIVE DATA:

throughput metrics:

IOs/sec:  1281.39

MBs/sec:    80.08

latency metrics:

Min_Latency(ms): 0

Avg_Latency(ms): 11

Max_Latency(ms): 449

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  2  1  0  0 1  2  5  8 11 14 15 13 10  7  5  3  2 1  1  0  0  0  1