{"id":565,"date":"2011-05-26T10:44:00","date_gmt":"2011-05-26T10:44:00","guid":{"rendered":"\/blogs\/paul\/post\/Survey-cores-vs-MAXDOP.aspx"},"modified":"2017-04-13T09:50:52","modified_gmt":"2017-04-13T16:50:52","slug":"survey-cores-vs-maxdop","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-cores-vs-maxdop\/","title":{"rendered":"Survey: cores vs. MAXDOP"},"content":{"rendered":"

\nI have a few surveys to editorialize but I'd like to kick off another one where you have to run a bit of code and send the results.<\/font>\n<\/p>\n

\nFor this one I'm interested in how you have your system configured for parallelism, given the number of processor cores and NUMA nodes configured.<\/font>\n<\/p>\n

\nFor systems using SQL Server 2005 onwards, the following code will work:<\/font>\n<\/p>\n

\n

\n\tSELECT
\n\t    [value_in_use] AS [MAXDOP],
\n\t    os.*
\n\tFROM
\n\t    sys.configurations,
\n\t    (SELECT
\n\t        COUNT (DISTINCT [parent_node_id]) AS [Nodes],
\n\t        COUNT (*) AS [Cores]
\n\t     FROM
\n\t        sys.dm_os_schedulers 
\n\t     WHERE
\n\t        [status] = 'VISIBLE ONLINE') AS os
\n\tWHERE
\n\t    [name] = 'max degree of parallelism';
\n\tGO<\/font>\n\t<\/p>\n<\/blockquote>\n

\nShoot me the results in email, spreadsheet, or as a comment on the blog. Comment #7 below has a Powershell script from Aaron Nelson (b<\/a>|t<\/a>) for all your servers – thanks!<\/font>\n<\/p>\n

\nIf you have any info on the general workload\/workload mix on the server, that would be helpful too.<\/font><\/font>\n<\/p>\n

\nThanks!<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

I have a few surveys to editorialize but I'd like to kick off another one where you have to run a bit of code and send the results. For this one I'm interested in how you have your system configured for parallelism, given the number of processor cores and NUMA nodes configured. For systems using […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66,91],"tags":[],"class_list":["post-565","post","type-post","status-publish","format-standard","hentry","category-performance-tuning","category-surveys"],"yoast_head":"\nSurvey: cores vs. MAXDOP - Paul S. Randal<\/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\/paul\/survey-cores-vs-maxdop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Survey: cores vs. MAXDOP - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"I have a few surveys to editorialize but I'd like to kick off another one where you have to run a bit of code and send the results. For this one I'm interested in how you have your system configured for parallelism, given the number of processor cores and NUMA nodes configured. For systems using […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-cores-vs-maxdop\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2011-05-26T10:44:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:50:52+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-cores-vs-maxdop\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-cores-vs-maxdop\/\",\"name\":\"Survey: cores vs. MAXDOP - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2011-05-26T10:44:00+00:00\",\"dateModified\":\"2017-04-13T16:50:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-cores-vs-maxdop\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-cores-vs-maxdop\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-cores-vs-maxdop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Survey: cores vs. MAXDOP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?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\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Survey: cores vs. MAXDOP - Paul S. Randal","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\/paul\/survey-cores-vs-maxdop\/","og_locale":"en_US","og_type":"article","og_title":"Survey: cores vs. MAXDOP - Paul S. Randal","og_description":"I have a few surveys to editorialize but I'd like to kick off another one where you have to run a bit of code and send the results. For this one I'm interested in how you have your system configured for parallelism, given the number of processor cores and NUMA nodes configured. For systems using […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-cores-vs-maxdop\/","og_site_name":"Paul S. Randal","article_published_time":"2011-05-26T10:44:00+00:00","article_modified_time":"2017-04-13T16:50:52+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-cores-vs-maxdop\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-cores-vs-maxdop\/","name":"Survey: cores vs. MAXDOP - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2011-05-26T10:44:00+00:00","dateModified":"2017-04-13T16:50:52+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-cores-vs-maxdop\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/survey-cores-vs-maxdop\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-cores-vs-maxdop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"Survey: cores vs. MAXDOP"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?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\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/565","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=565"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/565\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}