{"id":1636,"date":"2019-06-30T17:22:40","date_gmt":"2019-07-01T00:22:40","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1636"},"modified":"2020-08-04T17:10:35","modified_gmt":"2020-08-05T00:10:35","slug":"glenns-tech-insights-for-june-30-2019","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/","title":{"rendered":"Glenn&rsquo;s Technical Insights For June 30, 2019"},"content":{"rendered":"<p><em>(<span style=\"font-size: small;\">Glenn\u2019s Technical Insights\u2026<\/span><\/em><span style=\"font-size: small;\"> used to be part of our bi-weekly <\/span><a href=\"https:\/\/www.sqlskills.com\/join-the-sqlskills-insider-community\/\"><span style=\"font-size: small;\">newsletter<\/span><\/a><span style=\"font-size: small;\"> but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for SQL Server).<\/span><\/p>\n<h2><span style=\"font-size: medium;\"><span style=\"font-weight: bold;\">Leaked Intel Internal Memo About AMD<\/span><\/span><\/h2>\n<p><span style=\"font-size: small;\">There was quite a bit of <a href=\"https:\/\/wccftech.com\/intel-amd-competition-performance-per-dollar-risk-epyc-ryzen-threadripper-core\/\" target=\"_blank\" rel=\"noopener noreferrer\">discussion<\/a> and <a href=\"https:\/\/hothardware.com\/news\/intel-internal-memo-details-amd-competition-zen-2\" target=\"_blank\" rel=\"noopener noreferrer\">commentary<\/a> last week about a leaked memo from an internal Intel \u201cCircuit News\u201d employee portal. This memo, which is entitled <span style=\"font-size: small;\">&#8220;<a href=\"https:\/\/www.techpowerup.com\/256842\/intel-internal-memo-reveals-that-even-intel-is-impressed-by-amds-progress\" target=\"_blank\" rel=\"noopener noreferrer\">AMD competitive profile: Where we go toe-to-toe, why they are resurgent, which chips of ours beat theirs<\/a>&#8220;. The memo is a pretty frank analysis of Intel\u2019s current challenges in the desktop and server CPU market. Since it was written for internal consumption at Intel, it also seems to be little bit of a \u201cbuck up the troops\u201d document, which seems understandable in that context.<\/span><\/span><\/p>\n<p><span style=\"font-size: small;\">The 7nm <a href=\"https:\/\/www.tomshardware.com\/news\/amd-ryzen-3000-everything-we-know,38233.html\" target=\"_blank\" rel=\"noopener noreferrer\">AMD Ryzen 3000 series<\/a> processors and new <a href=\"https:\/\/www.anandtech.com\/show\/14588\/in-the-lab-msi-x570-motherboard-preview\" target=\"_blank\" rel=\"noopener noreferrer\">X570 chipset motherboards<\/a> are going to be on store shelves on July 7, 2019. The review embargos will expire on the same day, so we will probably have many reviews and benchmark numbers from a multitude of reputable 3rd party review sites. That is when we will finally know for sure whether the AMD Ryzen 3000 series processors actually have better single-threaded CPU performance than the best modern Intel processors.<\/span><\/p>\n<p><span style=\"font-size: small;\">This matters for SQL Server because the upcoming (Q3 2019) AMD 7nm EPYC \u201cRome\u201d processors use the same Zen 2 architecture as the Ryzen 3000 desktop processors. If Ryzen 3000 lives up to the expectations and hype, that will be a good omen for \u201cRome\u201d. SQL Server core-based licensing makes single-threaded CPU performance important if you want to maximize CPU performance and capacity while keeping license costs under control. <span style=\"font-size: small;\">Having a viable alternative to Intel for server processors is good for the market. Strong competition between AMD and Intel will force both companies to continue to innovate at a more rapid pace.<\/span><\/span><\/p>\n<p><span style=\"font-size: small;\"><span style=\"font-size: small;\">Despite what you may read and hear, Intel is not going to completely fail in those markets. They will lose some market share, and they will probably have to respond by <a href=\"https:\/\/www.digitimes.com\/news\/a20190621PD205.html\" target=\"_blank\" rel=\"noopener noreferrer\">offering lower prices<\/a> for many of their existing processors. Intel is definitely under pressure in those two market segments, and they just don\u2019t have an announced product release that will be a good competitive response for at least six to twelve months.<\/span><\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<h2><span style=\"font-size: medium;\"><span style=\"font-weight: bold;\">Microsoft Releases SQL Server 2019 CTP 3.1<\/span><\/span><\/h2>\n<p><span style=\"font-size: small;\">On June 26, 2019, <a href=\"https:\/\/cloudblogs.microsoft.com\/sqlserver\/2019\/06\/26\/sql-server-2019-community-technology-preview-3-1-is-now-available\/\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft released<\/a> SQL Server 2019 CTP 3.1. The release notes <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/what-s-new-in-sql-server-ver15?view=sqlallproducts-allversions\" target=\"_blank\" rel=\"noopener noreferrer\">are here<\/a>. Some of the highlights for the database engine include the ability to have the SQL Server setup program suggest recommended MIN and MAX <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/configure-windows\/server-memory-server-configuration-options?view=sqlallproducts-allversions#setting-the-memory-options-manually\" target=\"_blank\" rel=\"noopener noreferrer\">Server memory values<\/a> (which you can override) during installation.<\/span><\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/06\/sql-server-2019-ctp-3.1.png\"><img fetchpriority=\"high\" decoding=\"async\" style=\"display: inline; background-image: none;\" title=\"SQL Server 2019 CTP 3.1\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/06\/sql-server-2019-ctp-3.1_thumb.png\" alt=\"SQL Server 2019 CTP 3.1\" width=\"1028\" height=\"668\" border=\"0\" \/><\/a><\/p>\n<p><span style=\"font-size: small;\"><strong>Figure 1: Memory Configuration During Installation<\/strong><\/span><\/p>\n<p><span style=\"font-size: small;\">Another improvement is a new option for indexes, which is OPTIMIZE_FOR_SEQUENTIAL_KEY. This lets you <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-index-transact-sql?view=sqlallproducts-allversions#sequential-keys\" target=\"_blank\" rel=\"noopener noreferrer\">enable an optimization<\/a> within the database engine that helps improve throughput for high-concurrency inserts into the index. This option is intended for indexes that are prone to last-page insert contention, typically seen with indexes that have a sequential key such as an identity column, sequence, or date\/time column.<\/span><\/p>\n<p><span style=\"font-size: small;\">Microsoft continues to add new features to every SQL Server 2019 CTP release. So far, SQL Server 2019 looks like it is going to be good version release with a lot of genuinely useful new features and improvements compared to SQL Server 2017.<\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<p><span style=\"font-size: small;\"><span style=\"font-size: small;\">.<br \/>\n<\/span><\/span><\/p>\n<h2><\/h2>\n","protected":false},"excerpt":{"rendered":"<p>(Glenn\u2019s Technical Insights\u2026 used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for SQL Server). Leaked Intel Internal Memo About AMD There was quite a bit of [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,432,399,20],"tags":[433],"class_list":["post-1636","post","type-post","status-publish","format-standard","hentry","category-amd","category-glenns-technical-insights","category-hardware","category-intel","tag-glenns-tech-insights"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Glenn&rsquo;s Technical Insights For June 30, 2019 - 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\/glenns-tech-insights-for-june-30-2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Glenn&rsquo;s Technical Insights For June 30, 2019 - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"(Glenn\u2019s Technical Insights\u2026 used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for SQL Server). Leaked Intel Internal Memo About AMD There was quite a bit of [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-01T00:22:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-05T00:10:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/06\/sql-server-2019-ctp-3.1_thumb.png\" \/>\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\/glenns-tech-insights-for-june-30-2019\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/\",\"name\":\"Glenn&rsquo;s Technical Insights For June 30, 2019 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/06\/sql-server-2019-ctp-3.1_thumb.png\",\"datePublished\":\"2019-07-01T00:22:40+00:00\",\"dateModified\":\"2020-08-05T00:10:35+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/06\/sql-server-2019-ctp-3.1_thumb.png\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/06\/sql-server-2019-ctp-3.1_thumb.png\",\"width\":1028,\"height\":668},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Glenn&rsquo;s Technical Insights For June 30, 2019\"}]},{\"@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":"Glenn&rsquo;s Technical Insights For June 30, 2019 - 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\/glenns-tech-insights-for-june-30-2019\/","og_locale":"en_US","og_type":"article","og_title":"Glenn&rsquo;s Technical Insights For June 30, 2019 - Glenn Berry","og_description":"(Glenn\u2019s Technical Insights\u2026 used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for SQL Server). Leaked Intel Internal Memo About AMD There was quite a bit of [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/","og_site_name":"Glenn Berry","article_published_time":"2019-07-01T00:22:40+00:00","article_modified_time":"2020-08-05T00:10:35+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/06\/sql-server-2019-ctp-3.1_thumb.png","type":"","width":"","height":""}],"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\/glenns-tech-insights-for-june-30-2019\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/","name":"Glenn&rsquo;s Technical Insights For June 30, 2019 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/06\/sql-server-2019-ctp-3.1_thumb.png","datePublished":"2019-07-01T00:22:40+00:00","dateModified":"2020-08-05T00:10:35+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/06\/sql-server-2019-ctp-3.1_thumb.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/06\/sql-server-2019-ctp-3.1_thumb.png","width":1028,"height":668},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-june-30-2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Glenn&rsquo;s Technical Insights For June 30, 2019"}]},{"@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\/1636","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=1636"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1636\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}