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

54.6 MB/sec

MB Read/sec total

109.2 MB/sec

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)

4.9 sec

Average log disks Read Bytes/sec

2,132,267 (2,082MB/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)

117.4 GB

Time taken to backup each storage group

66 minutes

Average MB backed up/sec per storage group     7.6 MB/sec

Average MB backup up/sec per server

15.2 MB/sec

 

20