SQL network bandwidth job throttle

I have a backup job that runs several times a day, it takes up my whole iscsi pipe and causes me slow down in production.
I have another thread going here on the whole backend iscsi stuff.

however, I want to know if there is a way to throttle SQL server backup jobs specifically.
I do realize that this will cause my jobs to take a little longer and I don't know what the repercussion of that would be during the day time.

I am not a SQL guy, Im a network guy, and other than retooling my whole back end into Fiber for more bandwidth there has to be a way for me to use what I have.

Resource Governor might do it, but I am not familiar with the tool.

Thoughts and opinions would be great.

We are using SQL 2008 server standard. No R2.
Who is Participating?
Eugene ZConnect With a Mentor Commented:
additionally to 10GB NIC and 10GB Router switch
you can try to use Sql2008R2 native backup with Compression

the compressed file will help the network but will use some server (CPU/Memory) resourses

also you may try to use for higher compression 3rd party backup
e.g. sqlsafe from Idera (www.idera.com)

BTW: what kind backups do you run several times a day?
I hope it is not full backup.
if it is -- try full-> diff- trasn log
Brian CroweDatabase AdministratorCommented:
SQL Backups are fairly resource intensive which is why they are scheduled during relative down-times.  If this is a solution that might work for you we can help you work through how to accomplish it.  Maybe someone else will have another alternative.
DcpKingConnect With a Mentor Commented:
In addition to what EugeneZ said, check out


Good luck

wlacroixAuthor Commented:
We are using 2008 standard, so it does not have some of the fancy tools that 2008 R2 has.

Thanks guys.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.