{"id":1709,"date":"2019-09-13T07:41:53","date_gmt":"2019-09-13T14:41:53","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1709"},"modified":"2020-08-04T17:08:50","modified_gmt":"2020-08-05T00:08:50","slug":"glenns-tech-insights-for-september-13-2019","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-13-2019\/","title":{"rendered":"Glenn&rsquo;s Technical Insights For September 13, 2019"},"content":{"rendered":"<p><span style=\"font-size: small;\"><em>(Glenn\u2019s Technical Insights\u2026<\/em> 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 style=\"font-size: small;\">It also can just be technically related items that I find interesting.<\/span><\/span><\/p>\n<h2><span style=\"font-weight: bold; font-size: medium;\">AMD Ryzen 3000 BIOS Fix<\/span><\/h2>\n<p><span style=\"font-size: small;\">Over the last month or so, there has been a small controversy brewing in the hardware community about the maximum boost speeds for individual cores in AMD Ryzen 3000 series desktop processors. The allegation was that maximum boost speeds were sometimes 25-50 MHz below the rated maximum boost speed.<\/span><\/p>\n<p><span style=\"font-size: small;\">For example, the AMD Ryzen 7 3700X has a base clock speed of 3.6GHz and a Max Boost Clock of 4.4GHz. This is how AMD defines Max Boost Clock:<\/span><\/p>\n<blockquote><p><span style=\"font-size: small;\">\u201cMax boost for AMD Ryzen processors is the maximum frequency achievable by a single core on the processor running a bursty single-threaded workload. Max boost will vary based on several factors, including, but not limited to: thermal paste; system cooling; motherboard design and BIOS; the latest AMD chipset driver; and the latest OS updates.\u201d<\/span><\/p><\/blockquote>\n<p><span style=\"font-size: small;\">So, for example, people were seeing max boost speeds on the fastest core of a AMD Ryzen 7 3700X of perhaps 4350 or 4375 MHz instead of 4400 MHz.\u00a0 Not everyone was seeing this, but a significant number of people were seeing this issue. Just to be clear, this is not something you would notice in real life, but it was measurable in some benchmarks.<\/span><\/p>\n<p><span style=\"font-size: small;\"><span style=\"font-size: small;\">AMD has released a new AGESA version 1.0.0.3 ABBA to motherboard vendors that seems to improve this issue. Motherboard vendors should be releasing BIOS updates in the next 2-3 weeks. <span style=\"font-size: small;\"><span style=\"font-size: small;\">The reviews and benchmarks of the new BIOS I have seen typically are showing a single-threaded performance increase of 2-3%.<\/span><\/span><\/span><\/span><\/p>\n<p><span style=\"font-size: small;\"><span style=\"font-size: small;\"><span style=\"font-size: small;\">Here are the official AMD blog posts that cover this issue:<\/span><\/span><\/span><\/p>\n<blockquote><p><span style=\"font-size: small;\"><a href=\"https:\/\/community.amd.com\/community\/gaming\/blog\/2019\/09\/10\/ryzen-community-update-bios-updates-for-boost-and-idle-plus-a-new-sdk\" target=\"_blank\" rel=\"noopener noreferrer\">Ryzen Community Update: BIOS Updates for Boost and Idle, Plus a New SDK<\/a><\/span><\/p>\n<p><span style=\"font-size: small;\"><a href=\"https:\/\/community.amd.com\/community\/amd-corporate\/blog\/2019\/09\/10\/an-update-on-3rd-gen-amd-ryzen-boost-frequencies\" target=\"_blank\" rel=\"noopener noreferrer\">An Update on 3rd Gen AMD Ryzen Boost Frequencies<\/a><\/span><\/p><\/blockquote>\n<p><span style=\"font-size: small;\">Personally, I think this issue was blown way out of proportion. On the other hand, it is good that AMD addressed it pretty quickly. If you take the time to get everything updated, you will get a small performance increase for free.<\/span><\/p>\n<p><span style=\"font-size: small;\">If you want the best performance possible from your AMD Ryzen 3000 system, you need to do several things:<\/span><\/p>\n<ul>\n<li><span style=\"font-size: small;\">Make sure you are on Windows 10 Version 1903<\/span>\n<ul>\n<li><span style=\"font-size: small;\">This gives you a scheduler update so that Windows will favor the fastest core on your processor<\/span><\/li>\n<li><span style=\"font-size: small;\">It partially enables UEFI CPPC support (so that clock speed increases more quickly)<\/span><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"font-size: small;\"><span style=\"font-size: small;\">Make sure you are on the latest AMD chipset drivers<\/span><\/span>\n<ul>\n<li><span style=\"font-size: small;\">This gives you the UEFI CPPC support in Windows 10 1903, and other improvements<\/span><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"font-size: small;\">Make sure you update your BIOS<\/span>\n<ul>\n<li><span style=\"font-size: small;\">AMD continues to make small improvements with each new AGESA version<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<h2><span style=\"font-size: medium;\"><span style=\"font-weight: bold;\">September Release of Azure Data Studio<\/span><\/span><\/h2>\n<p><span style=\"font-size: small;\">On September 10, 2019, Microsoft <a href=\"https:\/\/cloudblogs.microsoft.com\/sqlserver\/2019\/09\/10\/the-september-release-of-azure-data-studio-is-now-available\/\" target=\"_blank\" rel=\"noopener noreferrer\">released the September version<\/a> of <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/download?view=sql-server-2017\" target=\"_blank\" rel=\"noopener noreferrer\">Azure Data Studio<\/a>, which is version 1.11.0. Microsoft continues to add new features to each release of Azure Data Studio. The <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/release-notes-azure-data-studio?view=sql-server-2017\" target=\"_blank\" rel=\"noopener noreferrer\">release notes are here<\/a>.<\/span><\/p>\n<p><span style=\"font-size: small;\">Some of the notable improvements include:<\/span><\/p>\n<blockquote><p><span style=\"font-size: small;\">Enable SQLCMD Mode<\/span><\/p>\n<p><span style=\"font-size: small;\">Enable Community Extension: Query Editor Boost<\/span><\/p>\n<p><span style=\"font-size: small;\">Notebook Improvements<\/span><\/p>\n<p><span style=\"font-size: small;\">Visual Studio Code August Release Merge 1.38<\/span><\/p>\n<p><span style=\"font-size: small;\">Bug fixes<\/span><\/p><\/blockquote>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/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). It also can just be technically related items that I find interesting. [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[432],"tags":[433],"class_list":["post-1709","post","type-post","status-publish","format-standard","hentry","category-glenns-technical-insights","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 September 13, 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-september-13-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 September 13, 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). It also can just be technically related items that I find interesting. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-13-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-13T14:41:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-05T00:08:50+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\/glenns-tech-insights-for-september-13-2019\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-13-2019\/\",\"name\":\"Glenn&rsquo;s Technical Insights For September 13, 2019 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2019-09-13T14:41:53+00:00\",\"dateModified\":\"2020-08-05T00:08:50+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-september-13-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-13-2019\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-13-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 September 13, 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 September 13, 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-september-13-2019\/","og_locale":"en_US","og_type":"article","og_title":"Glenn&rsquo;s Technical Insights For September 13, 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). It also can just be technically related items that I find interesting. [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-13-2019\/","og_site_name":"Glenn Berry","article_published_time":"2019-09-13T14:41:53+00:00","article_modified_time":"2020-08-05T00:08:50+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\/glenns-tech-insights-for-september-13-2019\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-13-2019\/","name":"Glenn&rsquo;s Technical Insights For September 13, 2019 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2019-09-13T14:41:53+00:00","dateModified":"2020-08-05T00:08:50+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-september-13-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-13-2019\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-13-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 September 13, 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\/1709","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=1709"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1709\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1709"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}