Automatic initialization of SQL Server 2017 AlwaysOn AG (15)
Comparative Analysis of performance Test
Take the xx library for testing. The data file is 8G. After backup, it is 600m:
Test scenario
Use time
one
Create through backup recovery and turn on backup compression
1 minute 29 seconds
two
Enable backup compression through automatic seed setting
1 minute 22 seconds
three
Enable data stream compression through automatic seed setting, backup compression and tracking flag 9567
1 minute 16 seconds
The above tests are all tested in the virtual machine environment on the same subnet, but not in the environment of remote and large database.
