You can improve the performance of backup and restore operations by modifying the following parameters for SQL iDataAgent:
|
Parameter |
Default Value |
Supported Value |
|---|---|---|
|
maximum size of data blocks used during backups |
65536 Bytes |
512 Bytes to 65536 Bytes |
|
number of buffers used to reserve bandwidth for data transfer |
20 |
1,2,3 |
|
maximum amount of data to be transferred at a time during backups |
2097152 Bytes |
65536 Bytes to 4194304 Bytes |
For more information on how to setup these parameters, refer to Enhancing SQL Backup Performance.