5.8

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.
About VCM Databases
Data associated with VCM is stored in its SQL Server databases.
All VCM databases are installed in the same SQL Server instance and must not be manually moved to
separate instances.
Database Name Description
VCM Contains configuration data for the VCM application itself, collected
data from Window systems and virtual infrastructure, change details
from all systems, and results of patch and compliance assessments. The
base name VCM is a default that may be changed.
VCM_Coll Provides operational state information for the Collector service, mainly
used to track details of running jobs and last contact state of managed
client systems.
VCM_UNIX Contains the collected managed machine data gathered from any Linux,
UNIX, or Mac Agents in the environment.
VCM_Raw For performance improvement, a database that temporarily holds
collection data before transformation into the VCM and VCM_UNIX
databases. The raw database should not be backed up and should not be
included in maintenance plans.
Table 4–1. VCM SQL Server Databases
Post-Installation
VMware, Inc.
45