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.
http://www.experts-exchange.com/Software/VMWare/Q_28229524.html#a39461983

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.
LVL 3
wlacroixAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
0
Eugene ZCommented:
additionally to 10GB NIC and 10GB Router switch
you can try to use Sql2008R2 native backup with Compression
http://technet.microsoft.com/en-us/library/bb964719(v=sql.105).aspx

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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DcpKingCommented:
In addition to what EugeneZ said, check out

http://technet.microsoft.com/en-us/library/cc280384.aspx

Good luck

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

Thanks guys.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.