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

1. Select Start > 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:

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 leave 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 leave free space in an index when running a maintenance plan.

VMware, Inc. 47