Skip to main content

CPU performance: Azure VM vs DELL M4700.

How powerful Azure VMs are in regard to CPU intensive operations (e.g., file compression)?
I decide to compare Azure VMs with my DELL M4700 laptop for file compression operations.


I created one VM of size A6 in the US-East2 region. Size A6 means 4 CPUs, 28 GB of RAM, and 127 GB on the system drive.
The second VM has size D4 in the US-East region. D4 is a newly announce type of VMs that comes with SSD disks presented as drive D: (non-persistent drive).
The D4 size has 8 CPUs', 28 GB of RAM, and 400 GB of the temporary drive D: (backed by SSD disks).

Both VMs report the same CPU information

Caption           : Intel64 Family 6 Model 45 Stepping 7
DeviceID          : CPU0
Manufacturer      : GenuineIntel
MaxClockSpeed     : 2200
Name              : Intel(R) Xeon(R) CPU E5-2660 0 @ 2.20GHz
SocketDesignation : None


On my DELL M4700 laptop the CPU information is

Caption           : Intel64 Family 6 Model 58 Stepping 9
DeviceID          : CPU0
Manufacturer      : GenuineIntel
MaxClockSpeed     : 2691
Name              : Intel(R) Core(TM) i7-3740QM CPU @ 2.70GHz
SocketDesignation : SOCKET 0


For testing the compression speed I used 7-zip v9.20 (64-bit) and these 8 text files (~2.2 GB in the combined size)

     Length Name
     ------ ----
      17160 BaseStationTimeZone.txt
       9484 ConfirmedDates.txt
   83204047 defile.txt
  345493392 DEMfile.txt
  230128233 EPfile.txt
    3347224 ProgramTitle.txt
  187435204 SWDfile.txt
 1494921513 SWOfile.txt


The resulting archive has a compression ratio 5%.

On the D4 VM all these text files were placed on the drive D: (SSD disks) and on A4 and the laptop the files were placed on the system disk

I ran the tests on each server multiple times (34 times on A4 and 62 on D4) using this batch file

@ECHO OFF

 SET LogFile="C:\TEMP\%~n0.LOG"
DEL %LogFile% 1>nul 2>nul
ECHO^.>yes.file

 FOR /L %%i IN (1,1,1000) DO (
DEL TEST.7z 1>nul 2>nul

 ECHO *********  Iteration # %%i  ************ >>%LogFile%
echo Start time:>>%LogFile%
TIME <yes.file >>%LogFile%
"c:\Program Files\7-Zip\7z.exe" a test *.TXT   1>nul 2>nul
echo End time:>>%LogFile%
TIME <yes.file >>%LogFile%
ECHO^.>>%LogFile%
ECHO^.>>%LogFile%
ECHO ---------                   ------------ >>%LogFile%
)


and averaged the results (there was very little variation in the results).
The results clearly show (the low the number the better) that when using a compression program like 7-zip (single threaded) then none of Azure VM's can challenge the DELL M4700 laptop





Comments

Post a Comment

Popular posts from this blog

Create 3-Node Windows 2012 Multi-subnet Cluster

Environment There are two Data centers connected via a WAN link. Two Windows 2012 Servers (called SQLDEV1 and SQLDEV2) are located in the Primary Data Center (on the IP subnet 192.168.79.0/24) and the third server is placed in the Secondary Data Center with the 192.168.69.0/24 subnet. We’ll be creating a three-node Windows cluster with no shared storage on the multi subnet network with a file share witness at the Primary Data Center. We’ll be using a file share witness to protect from the cluster failure in a situation when the network between the Data Centers is unavailable and one of the servers in the Primary Data Center is also down (or being rebooted). The final state will look like depicted above: -           Two Virtual IP’s will be assigned (192.168.76.218 and 192.168.69.134) to the cluster -           The servers at the Primary Data Center will have a vote (Vote=1) and the ...
2 comments
Read more

SQL 2012 AlwaysOn: Synchronous vs. Asynchronous commit. Performance impact

Recently I've had a chance to build a 3-server AlwaysOn environment distributed between the primary and secondary data centers. The configuration looks like this: Primary Data Center                         Secondary Data Center                        SQLDEV1                                        SQLDEV3          SQLDEV2 The availability group was crated with synchronous commit replicas on SQLDEV1 and SQLDEV2 and the replica on SQLDEV3 was configured for asynchronous commit. The link between the data centers was not great and when I pinged SQLDEV3 from SQLDEV1 I got these results Approximate round trip times in milli-seconds:     Minimum = 39ms, Maximum = 63ms, Average = 42ms I also created a very simp...
4 comments
Read more

SQL 2014 performance - Local disk vs. Azure Blob vs. Azure VM attached disk

Today I decided to compare SQL 2014 (RTM) performance when running a test against  - a local database (created on  WD7500BPKT - 750 GB 7200 RPM)  - a DB created on a disk attached to the A3 (3 cores, 7 GB) VM in Azure - a DB created on an Azure blob The VM in Azure was created in the US East region using the SQL 2014 template from the gallary provided by Microsoft. All databases were created with a single 10 GB data file (10 GB) and 1GB  log file. On the local SQL instance the DB was created as CREATE DATABASE TestDBonLocal ON     (NAME = file_data1, FILENAME = 'C:\TEMP\filedata1.mdf', SIZE = 10GB, FILEGROWTH = 256 MB )  LOG ON  (NAME = file_log1, FILENAME = 'C:\TEMP\filelog1.ldf', SIZE = 1GB, FILEGROWTH = 32 MB)  On the Azure VM the database on the attached disk (the disk was mapped as drive F:) was created as such CREATE DATABASE TestDBonDisk ON     (NAME = file_data1, FILENAME = 'F:\TMP\filedat...
2 comments
Read more