User`s guide

Configure Database File Growth
After VCM is installed, the installer creates a single 2GB data file and a 1GB log file. As data is added to
VCM through normal operations, these files will grow as required. File growth settings are set to the
default for Microsoft SQL Server 2008 R2. The default values may result in file fragmentation or sub-
optimal performance in some environments. This procedure describes how to set the AutoGrowth
property in each database. It is important to set the AutoGrowth value properly in each of the databases.
1. Select Start > All Programs > Microsoft SQL Server 2008R2 > SQL Server Management Studio.
2. Expand the SQL instance.
3. Expand Databases.
4. Right-click VCM and select Properties.
5. In the left pane, select Files.
6. In the Autogrowth column, click the ellipsis button.
7. Select Enable Autogrowth.
8. In the File Growth area, select In Percent and type or select 10. A value of 10% indicates that every
time the transaction log file grows it will grow by 10% of its current size. The value is critical in larger
environments where the log file can grow large even when using the Simple recovery model. Reserve
as much space as possible for your transaction log file so that it does not ever have to grow. This
configuration will result in the best performance.
9. In the Maximum File Size area, select Unrestricted File Growth and click OK.
10. Repeat the same procedure for VCM_Log.
11. Return to the database list and repeat the above procedures for all VCM-related databases.
Maintaining VCM After Installation
VMware, Inc. 239