SQL Backup 6

Performance expectations

This page compares the native SQL Server backup and restore performance against similar operations performed by SQL Backup.

The numbers shown here should be used only as a broad indicator of expected performance. The performance you can achieve using SQL Backup depends upon your own setup, such as hard disk configuration and throughput. For details of how you can optimize the speed of your backups, see Optimizing backup speed.

Results for a 22 GB database

This test was run on a four processor server with 6 GB of RAM. A single backup file was created using eight threads.

 Native backupSQL Backup (compression level 1)
Backup
Speed49.660 MB/sec101.517 MB/sec
File size19.781 GB7.766 GB
Elapsed time7 min 7 sec3 min 29 sec
Restore
Speed17.447 MB/sec43.465 MB/sec
Elapsed time20 min 15 sec8 min 9 sec

Results for a 306 GB database

This test was run on an eight processor server with 12 GB of RAM. A single backup file was created using sixteen threads.

 Native backupSQL Backup (compression level 1)
Backup
Speed83.849 MB/sec164.274 MB/sec
File size306.561 GB115.746 GB
Elapsed time7 min 7 sec3 min 29 sec
Restore
Speed29.682 MB/sec51.105 MB/sec
Elapsed time184 min 50 sec107 min 20 sec

Didn't find what you were looking for?