User`s guide

Configure SQL Server for VCM

SQL Server 2008 R2 is user friendly and designed so that even a novice Database Administrator (DBA) can

set up and operate a high performing database system. However, because VCM places such a heavy load

on the database, changes are required to the default settings to optimize SQL Server performance. By

understanding the SQL Server actions, a DBA can tune SQL Server for use with VCM.

For details about the SQL Server setting related to the VCM databases, see the VCM Installation and Getting

Started Guide.

SQL Server Database Settings

Configure the database settings for VCM.

Procedure

1. Click Start and select All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management

Studio.

2. Right-click the SQL instance that you installed and select Properties.

3. In the Select a page area, select Database Settings.

4. In the right pane, configure the following settings.

Default index fill factor: Type or select a percentage value, which specifies the amount of free

space in each index page when the page is rebuilt.

Set the fill factor to 80% to keep 20% free space available in each index page. Normally this setting is

specified as part of the maintenance plan wizard. If you configure the default fill factor using this

setting, remember to keep free space in an index when running a maintenance plan.

Recovery interval (minutes): Type or select 5. This setting configures the approximate amount of

time that SQL Server takes to run the recovery process.

The default setting is 0, which means that the system automatically adjusts this value. If you allow

SQL Server to automatically adjust the recovery interval, it will base the values on the historical

operation of the server. Because VCM constantly changes how it interacts with SQL Server (for

example, activities differ between an inspection request and a compliance run), the server spends a

lot of time constantly adjusting this value. By setting the recovery interval to 5 minutes, you allow

SQL Server to forget about tuning this value. In large environments, the recovery interval can affect

the overall performance of VCM.

5. Click OK to save the settings.

VMware, Inc.