Post-Installation Procedures
Chapter 2: Installing the Agent 27
6.
Select the Instance (ARCSERVE_DB) or the name of the instance for which
you wish to change configuration for the Agent for Microsoft SQL Server.
7.
Set the parameters under Virtual Device Configuration as follows:
■
Number of Stripes--
Determines the number of CPUs used to perform
backups. Set this value to match the number of CPUs in the database
server for the fastest backup performance. The default setting is 1 and
the maximum value is 32.
■
Number of Buffers--
The total number of VDI buffers (of maximum
transfer size) used to back up and restore. The default setting is 1. This
number cannot be less than the number of stripes.
■
Data Block Size (in bytes)--
All data transfer sizes are multiples of this
value. Values must be a power of 2 between 512 bytes and 64 KB
inclusive. The default is 65536 or 64 KB.
■
Maximum transfer size--
The maximum input or output request issued
by Microsoft SQL Server to the device. This is the data portion of the
buffer. This parameter value must be a multiple of 64 KB. The range is
from 64 KB to 4 MB. The default setting is 2097152 or 2 MB.
■
Maximum VDI Wait Time - Backup (ms)--
The time, in milliseconds,
a Virtual Device object waits for a response from Microsoft SQL Server
during a backup operation. This setting is also used by the agent when
waiting for parallel operations to synchronize or background operations
to complete, including during some parts of restore operations. The
default setting is 60000 ms (ten minutes).
■
Maximum VDI Wait Time - Restore (ms)--
The time, in milliseconds,
a Virtual Device object waits for a response from Microsoft SQL Server
during a restore. Increase this time if the database to be restored
contains very large data files. The default setting is 9000000 ms (2.5
hours).
