Performance tuning

Many factors can affect the backup and restore performance of Data Protection for SQL Server.

Some of these factors, such as hardware configuration, network type, and capacity, are not within the scope of Data Protection for SQL Server. Some options that are related to Data Protection for SQL Server can be tuned for optimum performance. The following issues affect performance.

For legacy and VSS backups, the RESOURCEUTILIZATION client option is important. This option increases or decreases the ability of the client to create multiple sessions. As the value increases, the client can start more sessions. The range for the option is from 1 to 10.

Legacy backups are a stream of bytes that Data Protection for SQL Server stores on the Tivoli® Storage Manager server.

VSS backups differ because these backups operate at the volume and file-level. In a situation where an SQL Server database is not fully allocated, a legacy backup might transfer a smaller amount of data for a Tivoli Storage Manager backup than for a VSS backup because a VSS backup transfers the entire file, regardless of its allocation.