Skip to main content

Posts

Showing posts from 2015

Azure VM's as powerful as high-end laptop... Almost

Microsoft on January 8th announce availability of a new series of VM sizes for Microsoft Azure Virtual Machines called the G-series. According to Microsoft "G-series sizes provide the most memory, the highest processing power and the largest amount of local SSD of any Virtual Machine size currently available in the public cloud". I decided to run a series of CPU-intensive tests on a G2 VM (4 cores, 56 GB) created in the West US region. For the test I used 7-zip (64-bit, v 9.20) to compress these 8 text files.            106,624 ConfirmedDates.txt            137,160 DataLoadTracking.txt        684,637,229 DEfile.txt      4,456,322,407 DEMfile.txt      1,951,333,329 EPfile.txt         12,975,399 ProgramTitle.txt      2,303,480,896 SWDfile.txt     24,168,394,643 SWOfile.txt Compression mode was  configured (in the '-m' parameter) as Low (-mx1), Fast (-mx3), and Normal (-mx5). The text files were placed on the D: drive within the G2 VM (this is a local n

SQL 2014 performance - Azure VM (SSD) vs. Local SSD vs. Azure DB (V12)

Microsoft has recently added a new G-series of VMs built on  the latest Intel Xeon processor E5 v3 family with plenty (up to 6.5 TB0 of  local Solid State Drive (SSD) space. Microsoft has also made available (in preview mode) the latest Azure SQL Database V12 which provides nearly complete compatibility with the Microsoft SQL 2014 Server engine and promises better performance (in the Premium level). I've decided to run my simple OLTP test against the database created: on the local instance of SQL 2014 with data and log files placed on the SATA hard drive (labelled below as DELL (HDD)) on the local instance of SQL 2014 with data and log files placed on the SSD drive (labelled below as DELL (SSD)) on the SQL 2014 installed within a G2-series VM (4 cores, 56 GB) with data and log files placed on an attached 100 GB drive (labelled below as Azure G2) on the SQL 2014 installed within a G2-series VM with data and log files placed on a virual disk created on top of the 8 x 100 G