Backup Transfer Speed

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » Backup Transfer Speed

Backup Transfer Speed

Rate Topic

Display Mode

Topic Options

Author

Message

tony_nichols_2012

Posted Tuesday, September 25, 2012 4:39 PM

Forum 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

David Webb-CDS

Posted Tuesday, September 25, 2012 4:45 PM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 9:00 PM
Points: 825, Visits: 5,698

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

tony_nichols_2012

Posted Tuesday, September 25, 2012 5:35 PM

Forum 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 »

Permissions