{"id":16237,"date":"2021-04-28T12:22:31","date_gmt":"2021-04-28T10:22:31","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/"},"modified":"2025-10-01T11:52:56","modified_gmt":"2025-10-01T09:52:56","slug":"sql-server-cpu-limitation-for-express-and-standard-edition","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/","title":{"rendered":"SQL Server CPU limitation for Express and Standard Edition"},"content":{"rendered":"

Introduction<\/h4>\n

When performing an audit on an SQL Server VM the first thing the system administrator told me was that there’s no issue with the CPU on this box, the monitoring shows it’s always around 50% usage.<\/p>\n

Problem<\/h4>\n

Here is the Task Manager:\"\"<\/p>\n

The average CPU usage on this VM is indeed 50% but half of the cores are stuck at 100%.
\nThere are two SQL Server instances installed on this server but they are both Express Edition.<\/p>\n

Compute capacity limits by Edition<\/h4>\n

As stated in the documentation<\/a> the compute capacity limit for SQL Server Express Edition is the lesser of 1 socket or 4 logical cores.\"\"<\/a><\/p>\n

So what happens is that the VM is configured with 2 sockets and 4 cores. Both instances are limited to 1 socket and therefore to 2 cores.
\nOne way to confirm this is to look at the sys.dm_os_sys_info<\/a> DMV.
\nWe can see that the scheduler_count is 2. Each scheduler is mapped to an individual processor (CPU) as described in the Thread and Task Architecture Guide<\/a>.<\/p>\n

\"\"<\/a><\/p>\n

The same information can also be retrieved from the Error Log with the following query.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
EXEC<\/code> sys.xp_readerrorlog 0, 1, N<\/code>'detected'<\/code>, N<\/code>'socket'<\/code>;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Solution<\/h4>\n

To improve this situation a solution without impacting the availability of the service would be to set a Processor Affinity<\/a> mask as it does not requires a restart of the service.
\nEach instance could be configured to use 2 differents cores so the workload would be balanced over the 4 cores.
\nI would not recommend doing this as the result is still sub-optimal.
\nThe best option here is to re-configure the VM with a single socket so both instances could use 4 cores.
\nThis is what we have done for this VM. Now the instances can use 4 schedulers and the load<\/p>\n

\"\"<\/a>\"\"<\/a><\/p>\n

Conclusion<\/h4>\n

There are some CPU limitations with non-Enterprise Editions of SQL Server.
\nMake sure you are aware of them and configure your VMs accordingly or you may face unexpected CPU contention on your instances.<\/p>\n

PS:<\/h4>\n

Just before publishing this post, I identified the same issue on another VM. This one has several SQL Server instances installed with Standard Edition.
\nThe Standard Edition is limited to the lesser of 4 sockets or 28 cores. The VM is configured with 8 cores but there are also 8 sockets. So only 4 cores can be used by SQL Server.
\nReconfiguring the VM with a maximum of 4 sockets will again allow the use of all cores.<\/p>\n

\"\"<\/a><\/p>\n

Written by Steven Naudet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction When performing an audit on an SQL Server VM the first thing the system administrator told me was that there’s no issue with the CPU on this box, the monitoring shows it’s always around 50% usage. Problem Here is the Task Manager: The average CPU usage on this VM is indeed 50% but half […]<\/p>\n","protected":false},"author":26,"featured_media":16238,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,99],"tags":[902,423,2325,2550],"type_dbi":[],"class_list":["post-16237","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-sql-server","tag-configuration","tag-cpu","tag-edition","tag-sql-server-2"],"acf":[],"yoast_head":"\nSQL Server CPU limitation for Express and Standard Edition - dbi Blog<\/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.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server CPU limitation for Express and Standard Edition\" \/>\n<meta property=\"og:description\" content=\"Introduction When performing an audit on an SQL Server VM the first thing the system administrator told me was that there’s no issue with the CPU on this box, the monitoring shows it’s always around 50% usage. Problem Here is the Task Manager: The average CPU usage on this VM is indeed 50% but half […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-28T10:22:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-01T09:52:56+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog21_1_CPU_TaskManager.png\" \/>\n\t<meta property=\"og:image:width\" content=\"908\" \/>\n\t<meta property=\"og:image:height\" content=\"825\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Microsoft Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Team\" \/>\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\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"SQL Server CPU limitation for Express and Standard Edition\",\"datePublished\":\"2021-04-28T10:22:31+00:00\",\"dateModified\":\"2025-10-01T09:52:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/\"},\"wordCount\":403,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog21_1_CPU_TaskManager.png\",\"keywords\":[\"configuration\",\"CPU\",\"Edition\",\"SQL Server\"],\"articleSection\":[\"Database Administration & Monitoring\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/\",\"name\":\"SQL Server CPU limitation for Express and Standard Edition - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog21_1_CPU_TaskManager.png\",\"datePublished\":\"2021-04-28T10:22:31+00:00\",\"dateModified\":\"2025-10-01T09:52:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog21_1_CPU_TaskManager.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog21_1_CPU_TaskManager.png\",\"width\":908,\"height\":825},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server CPU limitation for Express and Standard Edition\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\",\"name\":\"Microsoft Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"caption\":\"Microsoft Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server CPU limitation for Express and Standard Edition - dbi Blog","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.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server CPU limitation for Express and Standard Edition","og_description":"Introduction When performing an audit on an SQL Server VM the first thing the system administrator told me was that there’s no issue with the CPU on this box, the monitoring shows it’s always around 50% usage. Problem Here is the Task Manager: The average CPU usage on this VM is indeed 50% but half […]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/","og_site_name":"dbi Blog","article_published_time":"2021-04-28T10:22:31+00:00","article_modified_time":"2025-10-01T09:52:56+00:00","og_image":[{"width":908,"height":825,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog21_1_CPU_TaskManager.png","type":"image\/png"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"SQL Server CPU limitation for Express and Standard Edition","datePublished":"2021-04-28T10:22:31+00:00","dateModified":"2025-10-01T09:52:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/"},"wordCount":403,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog21_1_CPU_TaskManager.png","keywords":["configuration","CPU","Edition","SQL Server"],"articleSection":["Database Administration & Monitoring","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/","name":"SQL Server CPU limitation for Express and Standard Edition - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog21_1_CPU_TaskManager.png","datePublished":"2021-04-28T10:22:31+00:00","dateModified":"2025-10-01T09:52:56+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog21_1_CPU_TaskManager.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog21_1_CPU_TaskManager.png","width":908,"height":825},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cpu-limitation-for-express-and-standard-edition\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server CPU limitation for Express and Standard Edition"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4","name":"Microsoft Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","caption":"Microsoft Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16237"}],"version-history":[{"count":2,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16237\/revisions"}],"predecessor-version":[{"id":40608,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16237\/revisions\/40608"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/16238"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16237"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}