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.
1 commenti:
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.
Post a Comment