User`s guide

n
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.
SQL Server Processor Settings
In multi-processor environments, it is very important to configure the SQL Servers use of the processors
correctly by reserving a processor (removing it from SQL Server) for other functions such as the Collector
service and IIS.
NOTE IIS cannot make use of processor “affinity in multi-processor machines, so it uses them all
equally.
Hyper-threading is a machine-level setting that must be controlled via BIOS settings. The main
disadvantage of hyper-threading is that the two threads that run concurrently in one core share the same
cache. If these threads are performing calculations, they will not interfere with each other and will run
significantly faster than a single thread. However, if the threads are each working with a relatively large
block of data, as when processing a SQL query, their activities will step on each other’s cache, which can
cause the two threads to accomplish less work than could be accomplished by a single thread.
Configuring SQL Server Processor Settings
To set the maximum worker threads or boost the SQL Server priority, configure the SQLServer Processor
settings.
vCenter Configuration Manager Hardware and Software Requirements Guide
48 VMware, Inc.