Diskspd – SQLIO Replacement

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.

d3 d2 d1

Re-visiting SQLIO SSD Disk Performance Tests

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

 

 

SQLIO test – SSD vs. Non SSD on a laptop running Microsoft SQL Server

SQLIO Tests:

“SQLIO is a tool provided by Microsoft which can also be used to determine the I/O capacity of a given configuration.” Click here to down load the Disk subsystem benchmark application. Below is my test result on my laptop before and after l got a 240Gb Corsair Force 3 Solid State drive.

Before SSD:

After/with SSD:

WEI – Windows Exprerience Index jumped from 5.9 to 7.8 for disk performance.