HiveBrain v1.2.0
Get Started
← Back to all entries
gotchaMinor

Difference between Intel and AMD chips?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
chipsintelamddifferencebetweenand

Problem

I would like to know if there is a big dig difference between Intel and AMD chips in terms of how sql behaves? I've been told that their is a big difference between the chips depending on application. Is there any way I can test or someone can advise me on how I can go about troubleshooting this?

Thanks

Solution

Generally speaking, recent Intel processors perform better on most SQL Server workloads compared to recent AMD processors. Intel processors have better single-threaded performance and lower physical core counts (so the licensing costs are lower for SQL Server 2012). Even with the SQL Server Core Factor Table discount for AMD, it is pretty hard to make a case for using AMD processors for SQL Server 2012.

Context

StackExchange Database Administrators Q#27980, answer score: 8

Revisions (0)

No revisions yet.