Forum Discussion

ItsDaveTime's avatar
ItsDaveTime
9 years ago

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,...
7.7
Agent for Microsoft SQL Server
Backup and Recovery
NetBackup
Windows Server (2003-2008)
  • sdo's avatar
    sdo
    9 years ago

    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.

  • Michael_G_Ander's avatar
    Michael_G_Ander
    9 years ago

    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.

sdo's avatar
sdo
Moderator
9 years ago

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.