{"id":9606,"date":"2019-02-18T06:40:08","date_gmt":"2019-02-18T06:40:08","guid":{"rendered":"https:\/\/dbtut.com\/?p=9606"},"modified":"2019-02-18T06:40:08","modified_gmt":"2019-02-18T06:40:08","slug":"sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/","title":{"rendered":"SQL Server Edition Upgrade(SQL Server does not use all assigned CPUs)"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>There was a license-related change in the edition of Enterprise Edition in SQL Server 2012. There are two Enterprise Edition Models.<\/p>\n<ul>\n<li>Enterprise Edition with Server + Client Access License (CAL)<\/li>\n<li>enterprise edition: core based licensing<\/li>\n<\/ul>\n<p>If you set up Enterprise Edition with Server + Client Access License (CAL), you cannot use more than 20 cores per instance. This can prevent you from using your entire cpu. And it gives a warning as follows when opening instance.<\/p>\n<p>SQL Server detected 4 sockets with 15 cores per socket and 30 logical processors per socket, 120 total logical processors; using 40 logical processors based on SQL Server licensing. This is an informational message; no user action is required.<\/p>\n<p>In order for Instance to use all the cpu on the server, Edition Upgrade is required. Edition Upgrade is not a upgrade of sql server. In fact, the process will change only the licensing model. So it is safe. But if you are not using either Always On Availability Group or any other HA (High Availability) option, you should interrupt your system. In this article, we will perform the Edition Upgrade for a system that is always ON Availability Group.<\/p>\n<p>First, we will perform the edition upgrade for secondary instance. Then we will failover all AGs(Availability Groups) in the primary instance to the secondary instance. You can find the details of the secure failover process in the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/16\/sql-server-availability-group-failover-process\/\" target=\"_blank\" rel=\"noopener\">SQL Server Availability Group Failover Process<\/a>&#8221; .<\/p>\n<p>After the failover process, the primary will become secondary and the secondary will become the primary.\u00a0 Then, we will perform the edition upgrade for the other instance of the availability group(This is new secondary after failover). And we&#8217;ll failover again. In this way, our process will be completed.<\/p>\n<h3>Edition Upgrade:<\/h3>\n<p>First of all, we download Enterprise Core Edition and right click on the setup file and click Run As Administrator as if we were installing a new SQL Server.<\/p>\n<p id=\"YbDVMlW\"><img loading=\"lazy\" decoding=\"async\" width=\"545\" height=\"155\" class=\"size-full wp-image-9609  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a527a0befd.png\" alt=\"\" \/><\/p>\n<p>We click the Maintenance tab on the left hand side of the screen, and click Edition Upgrade.<\/p>\n<p>If the setup file you downloaded is licensed, you will see the Product Key. Click Next while the &#8220;Enter the product key&#8221; is selected.<\/p>\n<p id=\"xNXkQSH\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9611  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a5297f28e2.png\" alt=\"\" width=\"727\" height=\"363\" \/><\/p>\n<p>In the following screen, select &#8220;I accept license terms&#8221; and click next.<\/p>\n<p id=\"RgwTZaM\"><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"649\" class=\"size-full wp-image-9613  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a52bfe8b30.png\" alt=\"\" \/><\/p>\n<p>On the next screen, SQL Server checks to see if there&#8217;s anything blocking our Upgrade.<\/p>\n<p>If there is no problem, the following screen appears.<\/p>\n<p>I&#8217;ll perform the edition upgrade for the default instance. So I choose MSSQLSERVER and click next.<\/p>\n<p id=\"dISqYSY\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9615  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a52de577b0.png\" alt=\"\" width=\"696\" height=\"291\" \/><\/p>\n<p>Click Next, Next\u00a0 and finish the process by clicking Upgrade.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9606\" class=\"pvc_stats all  \" data-element-id=\"9606\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; There was a license-related change in the edition of Enterprise Edition in SQL Server 2012. There are two Enterprise Edition Models. Enterprise Edition with Server + Client Access License (CAL) enterprise edition: core based licensing If you set up Enterprise Edition with Server + Client Access License (CAL), you cannot use more than 20 &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9606\" class=\"pvc_stats all  \" data-element-id=\"9606\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[2054,2053],"class_list":["post-9606","post","type-post","status-publish","format-standard","","category-mssql","tag-sql-server-does-not-use-all-assigned-cpus","tag-sql-server-edition-upgrade"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":296,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server Edition Upgrade(SQL Server does not use all assigned CPUs) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"SQL Server Edition Upgrade,SQL Server does not use all assigned CPUs\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Edition Upgrade(SQL Server does not use all assigned CPUs) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"SQL Server Edition Upgrade,SQL Server does not use all assigned CPUs\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-18T06:40:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a527a0befd.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\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\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"SQL Server Edition Upgrade(SQL Server does not use all assigned CPUs)\",\"datePublished\":\"2019-02-18T06:40:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/\"},\"wordCount\":430,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a527a0befd.png\",\"keywords\":[\"SQL Server does not use all assigned CPUs\",\"SQL Server Edition Upgrade\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/\",\"name\":\"SQL Server Edition Upgrade(SQL Server does not use all assigned CPUs) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a527a0befd.png\",\"datePublished\":\"2019-02-18T06:40:08+00:00\",\"description\":\"SQL Server Edition Upgrade,SQL Server does not use all assigned CPUs\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a527a0befd.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a527a0befd.png\",\"width\":545,\"height\":155},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Edition Upgrade(SQL Server does not use all assigned CPUs)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Edition Upgrade(SQL Server does not use all assigned CPUs) - Database Tutorials","description":"SQL Server Edition Upgrade,SQL Server does not use all assigned CPUs","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:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Edition Upgrade(SQL Server does not use all assigned CPUs) - Database Tutorials","og_description":"SQL Server Edition Upgrade,SQL Server does not use all assigned CPUs","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-18T06:40:08+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a527a0befd.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"SQL Server Edition Upgrade(SQL Server does not use all assigned CPUs)","datePublished":"2019-02-18T06:40:08+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/"},"wordCount":430,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a527a0befd.png","keywords":["SQL Server does not use all assigned CPUs","SQL Server Edition Upgrade"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/","name":"SQL Server Edition Upgrade(SQL Server does not use all assigned CPUs) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a527a0befd.png","datePublished":"2019-02-18T06:40:08+00:00","description":"SQL Server Edition Upgrade,SQL Server does not use all assigned CPUs","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a527a0befd.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a527a0befd.png","width":545,"height":155},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/sql-server-edition-upgradesql-server-does-not-use-all-assigned-cpus\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"SQL Server Edition Upgrade(SQL Server does not use all assigned CPUs)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=9606"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9606\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}