SQLMint
Diskspd Utility application. This is a new robust storage Testing Tool (superseding SQLIO).
“”A feature-rich and versatile storage testing tool, Diskspd combines robust and granular IO workload definition with flexible runtime and output options, creating an ideal tool for synthetic storage subsystem testing and validation.””
Click here for the download link.
Sample output from a run on a basic PC hard drive.
Below are test results from re-running SQLIO tests on a laptop workstation used primariyl for Microsoft SQL Server 2008 R2/2012
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
SQLIO Tests:
Before SSD:
After/with SSD:
WEI – Windows Exprerience Index jumped from 5.9 to 7.8 for disk performance.