Storage Device - SQL Server Agent

Use this dialog box to establish the storage device related settings on the selected subclient. Note that all the options described in this help may not be available and only the options displayed in the dialog box are applicable to the agent or enabler for which the information is being displayed.

The following tabs are displayed:

Data Transfer Option

Use this tab to establish the options for data transfer. Note that all the options described in this help may not be available and only the options displayed in the dialog box are applicable to the agent for which the information is being displayed.

Software Compression

Indicates whether software compression for the subclient or instance is enabled or disabled, and if enabled whether it is performed on the client or MediaAgent computer.

  • On Client

    Click to enable software compression on the client computer.

  • On MediaAgent

    Click to enable software compression on the MediaAgent computer.

  • Use Storage Policy Settings

    Click to use the settings enabled on deduplicated storage policy copy.

    This option applies when subclient is associated with a storage policy copy that is deduplicated. See Copy Properties (Deduplication) - Advanced tab for compression settings on deduplicated storage policy copy.

  • Off

    Click to disable software compression.

Note that hardware compression has priority over the software compression. Hardware compression is established in the Data Path Properties dialog box. The above software compression option will take effect when the data path is associated with a disk library, or when hardware compression is disabled in the data path associated with tape libraries.

Note

For non-deduplicated storage policy copy, select On Client or On MediaAgent options to turn on compression, depending upon your environment.

Resource Tuning

Indicates the processes used by the client to transfer data based and whether bandwidth throttling is enabled or not.

  • Network Agents

    Specifies the number of data pipes/processes that the client uses to transfer data over a network. Increasing this value may provide better throughput if the network and the network configuration in your environment can support it. The default value is 2, and a maximum of 4 can be established if necessary.

  • Throttle Network Bandwidth (MB/HR)

    Specifies whether the backup throughput is controlled or not. (By default this option is not selected and therefore the throughput is not controlled). When selected, use the space to specify a value for the throughput. By default, this is set to 500. The minimum value is 2 and the maximum is 2147483647.

Use this option to set the backup throughput, based on the network bandwidth in your environment. Use this option to reduce the backup throughput, so that the entire network bandwidth is not consumed, especially in slow links. Increasing this value will end up consuming the bandwidth with the maximum throughput limited to the network bandwidth capability.

Note that throttling is done on a per Network Agent basis.

Application Read Size

This option specifies the amount of application data (such as SQL data, Windows File System data, and virtual machine data) backup jobs will read for each unit transferred to the MediaAgent.

The default value for this option is 2048 KB; however, this value may be increased to reduce the amount of data read from the given application, which in turn reduces the amount of I/O operations performed against it. As a result, overall backup performance may increase. However, backup memory usage may also increase, which may inadvertently consume additional resources from the application. Therefore, set this value at either the default value or match the block size directed by the application.

For steps to modify the value of Application Read Size, see Modifying Application Read Size.

Note

For SQL, the value of Application Read Size should be equal or greater than the value of Maximum Transfer Size. Otherwise, the backups might fail.

Deduplication

Use this tab to establish the options for deduplication on the subclient.

Enable Deduplication

Use this option to enable or disable deduplication for the subclient.

When enabled, you can choose to generate the signature (a component of deduplication) on the client or on the MediaAgent computer.

Note

  • The deduplication is supported on disk storage devices. Therefore, the deduplication options are applicable only if the subclient is associated with a storage policy containing disk storage.

  • For source-side deduplication, the signature generation always occurs on the client.

On Client

Click to enable signature generation on the client computer.

On MediaAgent

Click to enable signature generation on the MediaAgent computer.

Log Storage Policy

Log Storage Policy

Click to select from a list of available storage policies that can be used in transaction log backup jobs for the databases added. To associate a log storage policy to a new subclient or to change the log storage policy associated with an existing subclient, click one in the list.

Number of Streams for Transaction Log

Displays the number of streams used for backup operations. To change the number of streams, type the desired number.

Storage Policy

Use this tab to select or view storage policy settings on the selected subclient.

Data/Database/Transaction Log Storage Policy

Displays the storage policy to which this subclient is currently associated. To associate a storage policy to a new subclient or to change the storage policy associated with an existing subclient, click one in the list.

Incremental Storage Policy

Displays the name of the Incremental Storage Policy associated with this subclient, if the storage policy has the Incremental Storage Policy option enabled.

Data Paths

Click to view or modify the data paths associated with the primary storage policy copy of the selected storage policy.

Number of Data/Database/Transaction Log Backup Streams

Displays the number of streams used for backup operations. To change the number of streams, click one in the list. For DB2 DPF, be sure to set the appropriate number of streams for each database partition by double-clicking the appropriate Stream space and typing the desired number.

Client/Instance/Status/Stream

Displays the names of the instances according to current backup priority along with other associated information that are included in the Oracle RAC node. To change the backup priority of the instances, click the instance name as appropriate and use the directional arrows provided.

Maximum Backup Streams

For Informix, displays the maximum number of streams used for database backup operations, which is determined from the ONCONFIG file. The number of streams for backups cannot be set currently from the CommCell Console. Instead, you must set the BAR_MAX_BACKUP parameter in the $ONCONFIG file on the Informix client. Also, the number of streams specified by the storage policy must be greater than or equal to the number specified by the BAR_MAX_BACKUP parameter.

Data Threshold Streams

For Oracle RAC, specifies whether to run the backup job immediately when the total number of reserved streams is greater than or equal to the value in this field. If you click this option, use the space provided to change this value if desired.

Create Storage Policy

Click to launch the Create a Storage Policy wizard. Once the storage policy has been created, it will be displayed in the list of storage policies to which the selected subclient can be associated.

Buffer Size

Use this space to specify the size (in 4 KB pages) of each buffer to be used for building the backup image. The minimum value is 8, and the default value is 1024. If you select value 0, the value of the backbufz database manager configuration parameter will be used as the buffer allocation size.

Loading...