Installation guide

Configuring SQL Server for VCM

VCM relies heavily on its SQL databases for operation. You must update the default settings to optimize

SQL Server performance. These settings include the SQLServer database settings, processor settings, and

the Input/Output (I/O) configuration.

To ensure that VCM runs at peak performance and requires little operator intervention during its lifecycle,

set up a routine maintenance plan. See the VCM Administration Guide.

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 12–1. VCM SQL Server Databases

SQL Server Database Settings

Configure the database settings for VCM to optimize SQLServer performance.

VMware, Inc.

121