Question & Answer
Question
How do you use SQLIO Disk Subsystem Benchmark Tool (SQLIO)?
Answer
Contents
Question
How do you use SQLIO Disk Subsystem Benchmark Tool (SQLIO)?
Answer
Question
How do you use SQLIO Disk Subsystem Benchmark Tool (SQLIO)?
Answer
SQLIO is a Microsoft utility that is obtained from:? http://www.microsoft.com/en-us/download/details.aspx?id=20163.
Run these commands on the machines to be tested.? Ideally you run the tool with Tealeaf services stopped.? Otherwise you get Tealeaf I/O skewing the results (SQLIO shows you available capacity so you want Tealeaf removed from the results).? Note:? The ?dC is the drive parameter in this case Drive C:.? Point this to where the Canister or Indexes are located.
sqlio.exe -kW -t1 -s30 -b32 -dC
Run these commands on the machines to be tested.? Ideally you run the tool with Tealeaf services stopped.? Otherwise you get Tealeaf I/O skewing the results (SQLIO shows you available capacity so you want Tealeaf removed from the results).? Note:? The ?dC is the drive parameter in this case Drive C:.? Point this to where the Canister or Indexes are located.
sqlio.exe -kW -t1 -s30 -b32 -dC
sqlio.exe -kW -t1 -s30 -b64 -dC
sqlio.exe -kW -t1 -s30 -b128 -dC
These commands do reading (the previous 3 tests were writing)
sqlio.exe -kR -t1 -s30 -b32 -dC
sqlio.exe -kR -t1 -s30 -b64 -dC
sqlio.exe -kR -t1 -s30 -b128 -dC
Article Reference
00000479
Applies to version(s):? 4.0;4.5;4.6;5.0;5.1;6.0;6.1;6.2;7.0;7.1;7.2
"
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSERNK","label":"Tealeaf Customer Experience"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
More support for:
Tealeaf Customer Experience
Software version:
All Versions
Document number:
776805
Modified date:
08 December 2018
UID
ibm10776805
Manage My Notification Subscriptions