Warning: Constant WP_TEMP_DIR already defined in /var/www/html/blogs/glenn/wp-config.php on line 94

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902
{"id":863,"date":"2014-01-16T08:21:35","date_gmt":"2014-01-16T16:21:35","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=863"},"modified":"2018-11-13T10:52:23","modified_gmt":"2018-11-13T18:52:23","slug":"one-intel-processor-family-to-avoid-for-sql-server-20122014","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/","title":{"rendered":"One Intel Processor Family to Avoid For SQL Server 2012\/2014"},"content":{"rendered":"

On January 9, Intel launched the 22nm Intel Xeon E5-2400 v2 Product Family<\/a> (Ivy Bridge-EN) of processors for two-socket servers. For SQL Server usage, this is not a good processor family to choose for a new server.<\/p>\n

While these processors are a nice improvement over the older 32nm Intel Xeon E5-2400 Product Family<\/a> (Sandy Bridge-EN) of processors, they are still a particularly poor choice for SQL Server 2012 and SQL Server 2014, when compared to a 22nm Intel Xeon E5-2600 v2 Product Family<\/a> (Ivy Bridge-EP) processor with the same physical core count.<\/p>\n

The reason for this is that Microsoft simply charges for physical core licenses with SQL Server 2012 and SQL Server 2014 (in non-virtualized servers). The performance characteristics of the processor do not matter<\/em><\/strong> at all to Microsoft (for licensing purposes). Given this fact, it does not make any sense to pick a lower performance processor with the same number of physical cores, at least from a performance or scalability perspective. From a strict economic perspective, a lower performance processor (with the same core count) will cost a little bit less money, and it is likely to use less electrical power and require less heat dissipation in your data center. These cost savings are pretty small compared to the cost of SQL Server core licenses, and you are giving up a lot of performance to save a relatively small amount of money.<\/p>\n

If you compare the best models from the the entry-level E5-2400 v2 line<\/a> to the best models from the E5-2600 v2 line<\/a>, you will notice significantly higher base and turbo clock speeds, along with larger L3 cache sizes from the higher-end E5-2600 v2 line. You will also see higher QPI bandwidth, higher memory speed support and twice the memory capacity with the E5-2600 v2 line. The E5-2407 v2 processor does not have Turbo Boost or Hyper-Threading, which helps explain its very low price for a server-level processor.<\/p>\n\n\n\n\n\n\n\n
Processor<\/td>\nCores<\/td>\nBase Speed<\/td>\nTurbo Speed<\/td>\nL3 Cache<\/td>\nQPI<\/td>\nPrice<\/td>\n<\/tr>\n
E5-2407 v2<\/td>\n4<\/td>\n2.4GHz<\/td>\n2.4GHz<\/td>\n10MB<\/td>\n6.4GT\/s<\/td>\n$250.00<\/td>\n<\/tr>\n
E5-2430 v2<\/td>\n6<\/td>\n2.5Ghz<\/td>\n3.0GHz<\/td>\n15MB<\/td>\n7.2GT\/s<\/td>\n$551.00<\/td>\n<\/tr>\n
E5-2450 v2<\/td>\n8<\/td>\n2.5GHz<\/td>\n3.3GHz<\/td>\n20MB<\/td>\n8.0GT\/s<\/td>\n$1,107.00<\/td>\n<\/tr>\n
E5-2470 v2<\/td>\n10<\/td>\n2.4GHz<\/td>\n3.2GHz<\/td>\n25MB<\/td>\n8.0GT\/s<\/td>\n$1,440.00<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Table 1: Intel Xeon E5-2400 v2 Product Family Specifications<\/strong><\/p>\n

 <\/p>\n\n\n\n\n\n\n\n\n
Processor<\/td>\nCores<\/td>\nBase Speed<\/td>\nTurbo Speed<\/td>\nL3 Cache<\/td>\nQPI<\/td>\nPrice<\/td>\n<\/tr>\n
E5-2637 v2<\/td>\n4<\/td>\n3.5GHz<\/td>\n3.8GHz<\/td>\n15MB<\/td>\n8.0GT\/s<\/td>\n$996.00<\/td>\n<\/tr>\n
E5-2643 v2<\/td>\n6<\/td>\n3.5GHz<\/td>\n3.8GHz<\/td>\n25MB<\/td>\n8.0GT\/s<\/td>\n$1,552.00<\/td>\n<\/tr>\n
E5-2667 v2<\/td>\n8<\/td>\n3.3GHz<\/td>\n4.0GHz<\/td>\n25MB<\/td>\n8.0GT\/s<\/td>\n$2,057.00<\/td>\n<\/tr>\n
E5-2690 v2<\/td>\n10<\/td>\n3.0GHz<\/td>\n3.6GHz<\/td>\n25MB<\/td>\n8.0GT\/s<\/td>\n$2,057.00<\/td>\n<\/tr>\n
E5-2697 v2<\/td>\n12<\/td>\n2.7GHz<\/td>\n3.5GHz<\/td>\n30MB<\/td>\n8.0GT\/s<\/td>\n$2,618.00<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Table 2: Intel Xeon E5-2600 v2 Product Family Specifications<\/strong><\/p>\n

Just to be clear, you won\u2019t see these processors being offered in the same model servers. For example, the Dell PowerEdge R320, R420, and R520 servers will have the Xeon E5-2400 (Sandy Bridge-EN) or Xeon E5-2400 v2 (Ivy Bridge-EN) processors (which you don\u2019t want for SQL Server usage). The Dell PowerEdge R620, R720 and R720xd servers will have the Xeon E5-2600 (Sandy Bridge-EP) or Xeon E5-2600 v2 (Ivy Bridge-EP) processors (which you do want for SQL Server usage).<\/p>\n

As a final observation, the major server vendors are still offering the older 32nm Sandy Bridge along with the newer 22nm Ivy Bridge processors in most of their servers. In the cases I have seen, there is no discount for the older, slower, more power hungry Sandy Bridge processors, so there is really no good reason to choose one of the older Sandy Bridge processors.<\/p>\n","protected":false},"excerpt":{"rendered":"

On January 9, Intel launched the 22nm Intel Xeon E5-2400 v2 Product Family (Ivy Bridge-EN) of processors for two-socket servers. For SQL Server usage, this is not a good processor family to choose for a new server. While these processors are a nice improvement over the older 32nm Intel Xeon E5-2400 Product Family (Sandy Bridge-EN) […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,20,197,24,31,156],"tags":[198,205],"class_list":["post-863","post","type-post","status-publish","format-standard","hentry","category-sql-server-hardware","category-intel","category-ivy-bridge-en","category-processors","category-sql-server-2012","category-sql-server-2014","tag-intel-e5-2400-v2-product-family","tag-xeon-e5-2400-v2-series"],"yoast_head":"\nOne Intel Processor Family to Avoid For SQL Server 2012\/2014 - Glenn Berry<\/title>\n<meta name=\"description\" content=\"Glenn Berry describes the problems with the Intel Xeon E5-2400 v2 series\" \/>\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\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"One Intel Processor Family to Avoid For SQL Server 2012\/2014 - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Glenn Berry describes the problems with the Intel Xeon E5-2400 v2 series\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-16T16:21:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-13T18:52:23+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=\"3 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\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/\",\"name\":\"One Intel Processor Family to Avoid For SQL Server 2012\/2014 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2014-01-16T16:21:35+00:00\",\"dateModified\":\"2018-11-13T18:52:23+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"description\":\"Glenn Berry describes the problems with the Intel Xeon E5-2400 v2 series\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"One Intel Processor Family to Avoid For SQL Server 2012\/2014\"}]},{\"@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":"One Intel Processor Family to Avoid For SQL Server 2012\/2014 - Glenn Berry","description":"Glenn Berry describes the problems with the Intel Xeon E5-2400 v2 series","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\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/","og_locale":"en_US","og_type":"article","og_title":"One Intel Processor Family to Avoid For SQL Server 2012\/2014 - Glenn Berry","og_description":"Glenn Berry describes the problems with the Intel Xeon E5-2400 v2 series","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/","og_site_name":"Glenn Berry","article_published_time":"2014-01-16T16:21:35+00:00","article_modified_time":"2018-11-13T18:52:23+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/","name":"One Intel Processor Family to Avoid For SQL Server 2012\/2014 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2014-01-16T16:21:35+00:00","dateModified":"2018-11-13T18:52:23+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"description":"Glenn Berry describes the problems with the Intel Xeon E5-2400 v2 series","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/one-intel-processor-family-to-avoid-for-sql-server-20122014\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"One Intel Processor Family to Avoid For SQL Server 2012\/2014"}]},{"@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\/863","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=863"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/863\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}