Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup Transfer Speed Expand / Collapse
Author
Message
Posted Tuesday, September 25, 2012 4:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 7:21 AM
Points: 4, Visits: 37
I'm backing up terrabytes of production databases over a network.

My transfer rates are fluctuating between 3 Mbps to 20 Mbps using Lightspeed.
I have 32-bit SQL Server 2000 production servers backing up to a 64-bit file server on a gigabit connection.

Is there any way I can increase my network i/o throughput without having to update my production to 64-bit ?

TIA,
Tony
Post #1364352
Posted Tuesday, September 25, 2012 4:45 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 5:35 PM
Points: 902, Visits: 7,242
If you're writing to a single backup file, you might see some improvement by writing to multiple files. At some point you may reach the max for your disks before you reach the max for your network connection. Do you know what the target disks are supposed to support?



And then again, I might be wrong ...
David Webb
Post #1364353
Posted Tuesday, September 25, 2012 5:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 7:21 AM
Points: 4, Visits: 37
Target discs are on a large appliance where disc I/O is not an issue. I have lots of capacity on the write; other transactions are occurring and completing. The problem is getting the backup data from the SQL2k there, faster.

I have noticed the 12gigs of Ram on the target server, maxing, during the backups. I suspect its slowing down the transfer because its "full", but I don't know, just guessing.
I think its maxing (and paging) because the backed up databases being sent to it, are 10+ gigs large, and it has to capture it all, before/as it writes it to disc.

You know, maybe that's my problem. My network I/O goes up to 20 Mbps when nothing else is talking to the target server, but drops to like 3 Mbps when other servers start unloading on it. Again, its writing it all, but maybe the network I/O is dropping because the server is out of RAM to take on more.

Disk I/O has always been slightly faster than Network I/O, while memory is pegged.
Can anyone concur or rebuke my speculations?

Thanks,
Tony
Post #1364372
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse