Installation guide

specified as part of the maintenance plan wizard. By configuring the default fill factor using this

setting, do not forget to leave 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 it will take SQL Server to run the recovery process when it starts. The default setting

is 0, which means that the system automatically adjusts this value. The problem with allowing

SQL Server to automatically adjust the recovery interval is that it bases the values on historical

operation of the server. Because VCM is constantly changing the way it interacts with SQL

Server (for example, activities are very different between an inspection request and a compliance

run), the server spends a lot of time constantly adjusting this value. By setting it at 5 minutes, we

are essentially allowing SQL Server to forget about tuning this value. In large environments, this

setting can have a huge effect on the overall performance of VCM.

5. Click OK to save the settings.

SQL Server Processor Settings

In multi-processor environments, it is very important to configure SQL Servers use of the processors

correctly. It is important to reserve a processor (remove it from SQL Server) for other functions on the

system, such as the collector service and IIS.

NOTE IIS has some issues with multiprocessor machines in that it cannot make use of processor

“affinity”, so it uses them all equally.

The main disadvantage to Hyper-threading is that the two threads that are running concurrently in one

core share the same cache. If these threads are doing calculations, then they will not interfere with each

other and will really run significantly faster than a single thread. If, however, they are each working with a

relatively large block of data, as would be the case when processing a SQL query, then their activities will

“step” on each other’s cache, which can easily lead to the two threads getting less work done than one

thread could accomplish by itself. Hyper-threading is a machine-level setting that must be controlled via

BIOS settings.

vCenter Configuration Manager Hardware and Software Requirements Guide

74 VMware, Inc.