Tuning Performance for SQL Server Backups

To enhance the backup performance of the SQL Server Agent, you can tune the performance parameters such as Block Size, Buffer Count, Maximum Transfer Size.

Procedure

1. From the CommCell Browser, click Client Computers > client > SQL Server > instance.

2. Right-click the default subclient, and then click Properties.

   The Subclient Properties dialog box is displayed.

3. On the SQL Settings tab, choose the appropriate settings for the block size, buffers and transfer size:

   • In the Block Size box, type or select the number of data blocks you want to use during backups.

   • In the Buffer Count box, enter the number of buffers you want to use during data transfer.

   • In the Maximum Transfer Size box, enter the maximum number of bytes you want to transfer at a time during backups.

4. Click OK.

5. Verify that thevalue of Application Read Size is equal or greater than the value of Maximum Transfer Size. Otherwise, the backups might fail.