Streaming backup performance
For the ESRP Version 1.2 release, only streaming backup type is supported for testing in the
framework. There are three tests in this section. The first two tests measure the database and log read
I/O performance metrics by running a checksum on all the databases and log files. The third test is to
measure the end-to-end performance when the databases are backed up to disks.
Database read-only performance
The test is to measure the maximum rate at which databases could be streamed to backup devices.
The following table shows the average values per host.
MB read/sec per Storage group
MB Read/sec total
File size/Seconds taken
240401 MB/2201 seconds
Log read-only performance
The test is to measure the maximum rate at which the log files can be played against the databases.
The following table shows the average rate for 100 log files played in a single storage group. Each
log file is 5MB in size.
Average time to play one Log file (sec)
Average log disks Read Bytes/sec
Backup to disk performance
This test runs a streaming backup for all the database files, and stores them on disks. The following
table shows an average rate at which each storage group can be backed up.
Total database size per storage group (GB)
Time taken to backup each storage group
Average MB backed up/sec per storage group 7.6 MB/sec
Average MB backup up/sec per server