Red Gate forums :: View topic - Backup is slow with multiple files
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

Backup is slow with multiple files

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rowlettron



Joined: 30 Apr 2012
Posts: 3

PostPosted: Mon Apr 30, 2012 9:25 pm    Post subject: Backup is slow with multiple files Reply with quote

I am testing the backup on a test database that is 300GB and lives on a SQL 2005 cluster. When I backup with just one file, the backup is very quick. When I backup with 5 files on 5 different disk resources that are independent of each other, the time for the backup more than triples in duration. Any ideas?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2301

PostPosted: Tue May 01, 2012 9:15 am    Post subject: Reply with quote

Please see http://www.sqlbackuprestore.com/speedingupbackups.htm. Throughput also depends on where your database files are located, not just where the backup files are located. Also see the 'Optimizing backup speed' topic in the SQL Backup help file, which offers some guidance on how to measure and improve your backup throughput.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
rowlettron



Joined: 30 Apr 2012
Posts: 3

PostPosted: Tue May 01, 2012 1:36 pm    Post subject: Backup is slow with multiple files Reply with quote

I tried the link but it returns page not found. Where the data file is located should not make a difference since backing up to a single file goes very fast. But to provide insight on the data file, it is located on an independent LUN that does not share any disks with the backup LUNs.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2301

PostPosted: Tue May 01, 2012 3:32 pm    Post subject: Reply with quote

Please see http://www.sqlbackuprestore.com/speedingupbackups.htm

and also the 'Optimizing backup speed' topic in the SQL Backup help file. It should help you in determining where's the bottleneck when you back up to 5 files.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
rowlettron



Joined: 30 Apr 2012
Posts: 3

PostPosted: Tue May 01, 2012 3:42 pm    Post subject: Reply with quote

I looked at your page and I have already configured the database as suggested. It is only when I backup to multiple files using the tool that it slows down. I have done a native sql backup to a single file and multiple files. In both cases, throughput is great. I have backed up to a single file using the tool and throughput is great.

Disk speed - RAID 10 on a SAN. Database is broken up into 12 files with each file being on a separate independent LUN with no shared disks.
Database files - See bullet above.
Really use physically different disks - See first bullet
File fragmentation - Less than 5%
Transaction log - Stored on a separate independent LUN on the SAN
Backup files - Each one is stored on a different independent LUN.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2301

PostPosted: Tue May 01, 2012 4:07 pm    Post subject: Reply with quote

Could you please post some numbers on the speed you are seeing, for both native backups and SQL Backup backups, for backups to 1, 2, 3, 4 and 5 files? Would like to see the increase/decrease for both backup types, as you move from 1 file to 5 files.

Thanks.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group