Highlighted

Netbackup SQL servers - QOS?

We currently are backing up our sql servers using Netbackup, however netbackup is utilizing a ton of bandwidth to perform the backups.  We have a project in place to rectify this at the server level, however in the interim, is there any way to limit the amount of bandwidth utilized by Netbackup when connecting to SQL Server?

I've read some tech notes on using a LIMIT_BANDWIDTH setting, however it stated it wouldn't apply for SQL backups.  Is there any setting, whether in the backup batch file, client, etc. which would throttle the bandwidth utilized during backups of SQL server?

Thanks

2 Solutions

Accepted Solutions
Accepted Solution!

All I can think of is to use

All I can think of is to use another NIC in the client purely for backups - and hard set the NIC in the client and the port at the LAN switch both to 100Mb/s fdx (full duplex) - and this would limit the backup traffic to around 12 MB/s maximum.

View solution in original post

Accepted Solution!

Looking at NetBackup for SQL

Looking at NetBackup for SQL performance factors in the SQL guide I am thinking that playing with

MAXTRANSFERSIZE

BLOCKSIZE

NUMBER OF BUFFERS PER STRIPE (NUMBUF)

STRIPES

Could give you a lower bandwith.

EDIT:

Compression on the SQL side might help, but be aware then the dedup factor very bad if running to a dedup storage unit.

The standard questions: Have you checked: 1) What has changed. 2) The manual 3) If there are any tech notes or VOX posts regarding the issue

View solution in original post

2 Replies
Accepted Solution!

All I can think of is to use

All I can think of is to use another NIC in the client purely for backups - and hard set the NIC in the client and the port at the LAN switch both to 100Mb/s fdx (full duplex) - and this would limit the backup traffic to around 12 MB/s maximum.

View solution in original post

Accepted Solution!

Looking at NetBackup for SQL

Looking at NetBackup for SQL performance factors in the SQL guide I am thinking that playing with

MAXTRANSFERSIZE

BLOCKSIZE

NUMBER OF BUFFERS PER STRIPE (NUMBUF)

STRIPES

Could give you a lower bandwith.

EDIT:

Compression on the SQL side might help, but be aware then the dedup factor very bad if running to a dedup storage unit.

The standard questions: Have you checked: 1) What has changed. 2) The manual 3) If there are any tech notes or VOX posts regarding the issue

View solution in original post