SQL Server vNext Performance Windows vs Linux

I installed SQL vNext CTP 1.4 on Windows 2012 R2 and some Linux Machine in order to compare performance.

Basically Write Access is comparable on Windows and Linux but Read Access is much slower on Linux
OS
INSERT (msec)
Delta
(%)  
SELECT
(msec)
Delta
(%)
Windows Server 2012 R2
0,0123
0%
1,3278
0%
Linux CentOS 7 - EXT4
0,0128
4%
3,5359
166%
Linux CentOS 7 - XFS
0,0128
4%
3,405
156%
Linux CentOS 7 - BTRFS
0,0193
57%
3,6312
173%

Supported File System (EXT4/XFS) provide same performance, BTRFS is really BAD

Test has been made on virtual machines with 4 CPU and 4 GB of RAM with SqlQueryStressTool.
You can see the used script on my Github 

Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

1 commenti:

Unknown said...

My test supports your findings. My case is Centos 7 server vs Windows 2012R2 Standard. Using SQL Server Profiler monitoring SP:Starting and SP:Completed of the same stored procedure, the duration is 2600/230 and CPU is 31300/3500 averagely.