Performance expectations
Published 13 February 2013
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 backup | SQL Backup (compression level 1) | |
|---|---|---|
| Backup | ||
| Speed | 49.660 MB/sec | 101.517 MB/sec |
| File size | 19.781 GB | 7.766 GB |
| Elapsed time | 7 min 7 sec | 3 min 29 sec |
| Restore | ||
| Speed | 17.447 MB/sec | 43.465 MB/sec |
| Elapsed time | 20 min 15 sec | 8 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 backup | SQL Backup (compression level 1) | |
|---|---|---|
| Backup | ||
| Speed | 83.849 MB/sec | 164.274 MB/sec |
| File size | 306.561 GB | 115.746 GB |
| Elapsed time | 7 min 7 sec | 3 min 29 sec |
| Restore | ||
| Speed | 29.682 MB/sec | 51.105 MB/sec |
| Elapsed time | 184 min 50 sec | 107 min 20 sec |
