{"id":968,"date":"2015-07-24T12:58:14","date_gmt":"2015-07-24T19:58:14","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=968"},"modified":"2018-11-13T10:52:38","modified_gmt":"2018-11-13T18:52:38","slug":"processor-selection-for-sql-server","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/","title":{"rendered":"Processor Selection for SQL Server"},"content":{"rendered":"

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.<\/font><\/p>\n

I will update this post as I write new posts and articles. Updated March 17, 2018<\/strong>.<\/font><\/p>\n


<\/font><\/p>\n

SQLskills.com Blog posts:<\/font><\/strong><\/p>\n

\n

Upgrading SQL Server\u2013 Intel Xeon-W Family<\/font><\/a><\/p>\n

Upgrading SQL Server\u2013 Top Five Intel Xeon Scalable Processors for SQL Server Usage<\/font><\/a><\/p>\n

Upgrading SQL Server\u2013Replacing Slow Hardware Part 2<\/font><\/a><\/p>\n

Upgrading SQL Server\u2013Replacing Slow Hardware<\/font><\/a><\/p>\n

Upgrading SQL Server\u2013Preferred AMD EPYC 7000 Processors<\/font><\/a><\/p>\n

Upgrading SQL Server\u2013Preferred Intel Xeon Scalable Processors<\/font><\/a><\/p>\n

Upgrading SQL Server\u2013Generational Performance Increases for Two-Socket Servers<\/font><\/a><\/p>\n

SQL101: AMD EYPC 7000 Series Processors<\/font><\/a><\/p>\n

SQLskills SQL101: Processor Selection for SQL Server<\/font><\/a><\/p>\n

New Flagship Xeon E5 and E7 Processors<\/font><\/a><\/p>\n

Intel Xeon E7 Processor Generational Performance Comparison<\/font><\/a><\/p>\n

More Intel Broadwell Server Processor Families Available<\/font><\/a><\/p>\n

Recommended Intel Xeon E5-2600 v4 Processors for SQL Server<\/font><\/a><\/p>\n

Interesting Upcoming Intel Processors<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Intel Xeon E7 v3 Product Family Released<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

TPC-E Single-Threaded Performance Leaderboard<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Intel Xeon E5-2600 v3 Product Family and SQL Server<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Recommended Intel Processors For SQL Server 2014 OLTP Workloads<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Two New TPC-E Benchmark Results for Intel Xeon Ivy Bridge-EX Processors<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Bigger Database Servers Get Faster<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

One Intel Processor Family to Avoid For SQL Server 2012\/2014<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Updates on Intel Xeon Ivy Bridge Server Processor Launch Schedules<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Using TPC-E OLTP Benchmark Scores to Compare Processors<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Intel Xeon E5-2600 v2 Series Processors (Ivy Bridge-EP) in Q3 2013<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

New AMD-based TPC-E Benchmark Result<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Deciding What Processor to Choose for SQL Server 2012<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Two Database Server Models Compared<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Recommended Intel Processors For SQL Server 2012 OLTP Workloads<\/font><\/a><\/p>\n<\/blockquote>\n

<\/p>\n

Articles from SQLPerformance.com<\/font><\/strong><\/p>\n

\n

New AMD Processor Families Compare Well to New Intel Processors<\/a><\/h3>\n

Intel Xeon Scalable Processors and SQL Server 2017<\/a><\/h3>\n

Selecting and Configuring Hardware for SQL Server 2016 Standard Edition<\/a><\/h3>\n

Memory\/Storage Technology Hierarchy and SQL Server<\/a><\/h3>\n

Database Hardware and Infrastructure Trends<\/font><\/a><\/p>\n

Practical Processor Selection for SQL Server 2014\/2016 OLTP Workloads<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Recommended Intel Processors for SQL Server 2014 \u2013 March 2015<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Database Server Hardware Trends<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Recommended Intel Processors for SQL Server 2014 Workloads<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Selecting a Processor for SQL Server 2014 \u2013 Part 2<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Selecting a Processor for SQL Server 2014 \u2013 Part 1<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

SQL Server Database Server Hardware Upgrade Case Study<\/font><\/a><\/p>\n


\n<\/font><\/p>\n

Selecting a Processor for SQL Server 2012<\/font><\/a><\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,24],"tags":[44],"class_list":["post-968","post","type-post","status-publish","format-standard","hentry","category-sql-server-hardware","category-processors","tag-processor-selection"],"yoast_head":"\nProcessor Selection for SQL Server - Glenn Berry<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Processor Selection for SQL Server - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"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 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-24T19:58:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-13T18:52:38+00:00\" \/>\n<meta name=\"author\" content=\"Glenn Berry\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glenn Berry\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/\",\"name\":\"Processor Selection for SQL Server - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2015-07-24T19:58:14+00:00\",\"dateModified\":\"2018-11-13T18:52:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Processor Selection for SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Processor Selection for SQL Server - Glenn Berry","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Processor Selection for SQL Server - Glenn Berry","og_description":"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 […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/","og_site_name":"Glenn Berry","article_published_time":"2015-07-24T19:58:14+00:00","article_modified_time":"2018-11-13T18:52:38+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/","name":"Processor Selection for SQL Server - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2015-07-24T19:58:14+00:00","dateModified":"2018-11-13T18:52:38+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/processor-selection-for-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Processor Selection for SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/968","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=968"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/968\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=968"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=968"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=968"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}