Trial Azure: Database backup compressed file recovery speed test on virtual machine

Test environment: Windows Azure Shanghai Room, virtual machine configured for large (quad core, 7 GB memory), the disk situation is shown in the figure below.

The database backup compression file is greater than 12.0 GB (12,914,327,552 bytes), placed in temporary Storage (D:).

The database restore operation commands are as follows:

RESTORE DATABASE [Cnblogstext]  from DISK = N ' D:\cnblogstext.bak '  with FILE = 1,  
Move N ' Cnblogstext ' to n ' F:\DATA\CNBlogsText.mdf ',  
Move N ' Cnblogstext_log ' to n ' F:\Log\CNBlogsText.ldf ',  nounload,  STATS = 5

That is, restore from D to disk F.

The measured recovery takes 1 hours, 44 minutes and 15 seconds.

Comparison with other cloud service providers:

April on the Ali Cloud Database restore test, when the database backup compressed files around 18G, on the virtual machine recovery takes 1 hours 16 minutes (recovery in RDS only 10 minutes), see Cloud Computing Road: Trial Aliyun RDS-10 minutes vs 1 hours 16 minutes.

Recovering about 12G of database backup compressed files on Ucloud high-performance virtual machines in August took 18 minutes and 50 seconds.

Note: This test is only for azure virtual machines, not SQL Azure,sql Azure, which is much higher than virtual machines.

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/Servers/cloud-computing/