5.7

n
To remove a processor from SQL Server and reserve it for the OS, uncheck the check box next to
the processor. Remove the processor that the network card will use so that network
communication does not affect SQL Server. Most network cards use the first processor, but some
Intel network cards use the last processor.
n
When hyperthreading is enabled, the processor list normally starts at 0 and lists the number of
physical cores, and then repeats to include the hyperthread-created processors. For example, to
unlink the first core from SQL in a four-CPU hyperthreaded system, which includes eight
processors according to the OS, clear the check boxes next to CPU 0 and CPU 4. This is the
preferred logical processor enumeration sequence recommended to BIOS vendors by Intel as part
of its Netburst architecture. A BIOS that uses this preferred sequence shows the two threads of the
first Hyper-threaded CPU as logical CPU 0 and 1. To confirm which algorithm is used, verify with
the BIOS vendor or compare the SQL Server processor affinity options with and without
hyperthreading enabled.
8. Click OK to save the settings.
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.
Post-Installation
VMware, Inc.
45