Question & Answer
Question
How do you use Disk Subsystem Benchmark Tool (SQLIO) to Measure Index Performance?
Answer
Contents
Question
How do you use Disk Subsystem Benchmark Tool (SQLIO) to Measure Index Performance?
Answer
Question
How do you use Disk Subsystem Benchmark Tool (SQLIO) to Measure Index Performance?
Answer
The Knowledgebase Article: 16642:? How do you use SQLIO Disk Subsystem Benchmark Tool (SQLIO) explains how to use the Microsoft utility SQILIO to measure the general performance of disk I/O subsystems and its instructions specify the use of block sizes:? 32 KB 64 KB and 128 KB.
However these test block sizes may not accurately measure the disk ability to handle indexing activity since that activity uses a 4 KB block size and this smaller block imposes significantly more I/O overhead on the disk channel.? If you suspect that the index disk drive cannot keep up with the indexing load check it by using the following commands:
sqlio.exe -kW -t1 -s30 -b4 -dX (-dX is the disk drive parameter where the indexes are)
sqlio.exe -kR -t1 -s30 -b4 -dX
The difference here is the -b4 parameter which specifies a 4 KB block size.
Article Reference
00001067
Applies to version(s):? 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:
776843
Modified date:
08 December 2018
UID
ibm10776843
Manage My Notification Subscriptions