Intel Ice Lake Xeon Or Amd Epyc Milan?For SQL Sever

wyzdic

New Member
Jul 22, 2019
1
0
1
I want to assemble a server, in order to run SQL Server faster, the plan is to buy Milan, but a seller tells my database application to choose Intel will be more fast, I am confused, which one should I choose?
 

i386

Well-Known Member
Mar 18, 2016
2,673
789
113
32
Germany
"it depends"

With an unlimited budget you could get intel systems with 8 cpu sockets and support for 12+ TByte ram (I wrote this because you didn't post about budget or requirements :D)

With a limited budget you have to analyse your workloads and see what's the bottleneck and if you can fix or change it (eg not enough ram -> more io to slower storage -> get faster storage or more ram)
 

986box

Member
Oct 14, 2017
100
12
18
41
Why not use one of the cloud vendor? It may not be the cheapest route but you dont not need to deal with space and backup generator.
What version and edition are you planning to use?
 

KarelG

Member
Jan 29, 2020
48
13
8
Use cloud vendors and benchmark yourself both cpus. It really depends, I'm inclined to bet on Epyc here due to its bigger L3, but it really depends. Size is not everything and I'm not sure how big hot ram for your queries will be. If bigger than either L3, then even Intel may be faster under some conditions.