Veritas NetBackup™ Appliance Capacity Planning and Performance Tuning Guide
- About this Guide
- Section I. Capacity planning
- Analyzing your backup requirements
- Designing your backup system
- Section II. Best Practices
- Section III. Performance tuning
- Section IV. Quick reference to Capacity planning and Performance tuning
Microsoft SQL
To achieve higher deduplication rates while performing SQL server backups, implement one of the following options:
Table: Best practices to perform SQL server backups
NetBackup for SQL Agent | Use the NetBackup for SQL Agent for better deduplication rates. |
| Ensure COMPRESSION is set to 1 and MATCH_PDRO = 0 in |
NO_COMPRESSION | Make sure NO_COMPRESSION setting is enabled on SQL Server 2008 and higher. |
BLOCKSIZE | Use default BLOCKSIZE for SQL database backups. |
BUFFERCOUNT | BUFFERCOUNT defines number of I/O buffers leveraged for a backup process. Use 2 buffers per stripe for good deduplication performance |
MAXTRANSFERSIZE | Leverage this parameter for faster backup speeds. Be careful, that you have enough memory while defining both BUFFERCOUNT and MAXTRANSFERSIZE. Otherwise, the backups could result in error 11's and 13's. |
Defragmentation | Defragmentation of the SQL databases will also affect the deduplication rates. With SQL databases, more frequently defragmentation is performed, lower the deduplication rates. Instead of performing defragmentation regularly, only perform when certain thresholds are reached. |
STRIPES | This parameter determines the number of simultaneous backup streams per single backup operation. Use multiple stripes for faster backups. STRIPES parameter with SQL backups does not seem to have any negative effect on the deduplication rates. |
More Information