Over the past six years, I have written a number of articles and blog posts about processor selection for SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017. To make them easier to find for others (and myself), I have put together a list of links, in reverse chronological order.
I will update this post as I write new posts and articles. Updated March 17, 2018.
SQLskills.com Blog posts:
Upgrading SQL Server– Intel Xeon-W Family
Upgrading SQL Server– Top Five Intel Xeon Scalable Processors for SQL Server Usage
Upgrading SQL Server–Replacing Slow Hardware Part 2
Upgrading SQL Server–Replacing Slow Hardware
Upgrading SQL Server–Preferred AMD EPYC 7000 Processors
Upgrading SQL Server–Preferred Intel Xeon Scalable Processors
Upgrading SQL Server–Generational Performance Increases for Two-Socket Servers
SQL101: AMD EYPC 7000 Series Processors
SQLskills SQL101: Processor Selection for SQL Server
New Flagship Xeon E5 and E7 Processors
Intel Xeon E7 Processor Generational Performance Comparison
More Intel Broadwell Server Processor Families Available
Recommended Intel Xeon E5-2600 v4 Processors for SQL Server
Interesting Upcoming Intel Processors
Intel Xeon E7 v3 Product Family Released
TPC-E Single-Threaded Performance Leaderboard
Intel Xeon E5-2600 v3 Product Family and SQL Server
Recommended Intel Processors For SQL Server 2014 OLTP Workloads
Two New TPC-E Benchmark Results for Intel Xeon Ivy Bridge-EX Processors
Bigger Database Servers Get Faster
One Intel Processor Family to Avoid For SQL Server 2012/2014
Updates on Intel Xeon Ivy Bridge Server Processor Launch Schedules
Using TPC-E OLTP Benchmark Scores to Compare Processors
Intel Xeon E5-2600 v2 Series Processors (Ivy Bridge-EP) in Q3 2013
New AMD-based TPC-E Benchmark Result
Deciding What Processor to Choose for SQL Server 2012
Two Database Server Models Compared
Recommended Intel Processors For SQL Server 2012 OLTP Workloads
Articles from SQLPerformance.com
New AMD Processor Families Compare Well to New Intel Processors
Intel Xeon Scalable Processors and SQL Server 2017
Selecting and Configuring Hardware for SQL Server 2016 Standard Edition
Memory/Storage Technology Hierarchy and SQL Server
Database Hardware and Infrastructure Trends
Practical Processor Selection for SQL Server 2014/2016 OLTP Workloads
Recommended Intel Processors for SQL Server 2014 – March 2015
Database Server Hardware Trends
Recommended Intel Processors for SQL Server 2014 Workloads
Selecting a Processor for SQL Server 2014 – Part 2
Selecting a Processor for SQL Server 2014 – Part 1
SQL Server Database Server Hardware Upgrade Case Study