5.7

Use SQLIO to Determine I/O Channel Throughput
SQLIO is a tool that determines the I/O capacity of a SQL configuration. To predict how well VCM will
function on a particular I/O configuration and to obtain a baseline of how well the I/O subsystem
functions, run SQLIO before you install VCM.
After you download and install SQLIO, configure the following SQLIO settings to ensure an accurate
report of I/O throughput.
n
64K Block Size
n
4 Threads
n
2GB File Size minimum
n
Sequential I/O
When you execute SQLIO, verify that you create baseline information for each I/O channel (logical disk) to
be used for VCM data, as well as testing both read and write operations.
Configuring SQL Server for VCM
VMware, Inc.
127