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.