{"id":569,"date":"2009-06-16T19:45:26","date_gmt":"2009-06-16T19:45:26","guid":{"rendered":"\/blogs\/news\/archive\/2009\/06\/16\/sql-server-on-windows-7-windows-2008-r2-with-more-than-64-cpus.aspx"},"modified":"2009-06-16T19:45:26","modified_gmt":"2009-06-16T19:45:26","slug":"sql-server-on-windows-7-windows-2008-r2-with-more-than-64-cpus","status":"publish","type":"post","link":"https:\/\/plexuk.co.uk\/?p=569","title":{"rendered":"SQL Server on Windows 7 \/ Windows 2008 R2 with more than 64 CPUs"},"content":{"rendered":"<p>The release of the Windows 7\/Windows 2008 R2 will support more than 64 CPUs.&#160;&#160; It is also documented that the SQL Server 10.5 (Kilimanjaro &#8211; <a href=\"http:\/\/news.cnet.com\/8301-13860_3-10236936-56.html\">http:\/\/news.cnet.com\/8301-13860_3-10236936-56.html<\/a>) will extend the SQL Server Engine to support more than 64 CPUs.<\/p>\n<p><em>Question: What if I am running a version of SQL Server that is not greater than 64 CPU aware?<\/em><\/p>\n<p>Windows 7 introduces processor groups of up to 64 CPUs per group.&#160;&#160; It is not common, but it is possible, to have configurations with unbalanced group CPU counts.&#160;&#160; For example, on a machine with 96 CPUs you could have two groups 1 == 64 CPUS and 2 == 32 CPUs.&#160; If you have SQL Server 2008 Enterprise installed it can use up to 64 CPUs.&#160;&#160; You don\u00e2\u20ac\u2122t want it associated with group 2 and only 32 CPUs.<\/p>\n<p>Windows provides capability to assign a service to a preferred node using SC.exe.&#160; You may need to use SC.exe to establish a preferred node for the SQL Server based service.<\/p>\n<p>Full Article &#8211; <a title=\"http:\/\/blogs.msdn.com\/psssql\/archive\/2009\/06\/16\/sql-server-on-windows-7-windows-2008-r2-with-more-than-64-cpus.aspx\" href=\"http:\/\/blogs.msdn.com\/psssql\/archive\/2009\/06\/16\/sql-server-on-windows-7-windows-2008-r2-with-more-than-64-cpus.aspx\">http:\/\/blogs.msdn.com\/psssql\/archive\/2009\/06\/16\/sql-server-on-windows-7-windows-2008-r2-with-more-than-64-cpus.aspx<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The release of the Windows 7\/Windows 2008 R2 will support more than 64 CPUs.&#160;&#160; It is also documented that the SQL Server 10.5 (Kilimanjaro &#8211; http:\/\/news.cnet.com\/8301-13860_3-10236936-56.html) will extend the SQL Server Engine to support more than 64 CPUs. Question: What if I am running a version of SQL Server that is not greater than 64 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[338],"class_list":["post-569","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-uncategorized"],"_links":{"self":[{"href":"https:\/\/plexuk.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/plexuk.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/plexuk.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/plexuk.co.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/plexuk.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=569"}],"version-history":[{"count":0,"href":"https:\/\/plexuk.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/569\/revisions"}],"wp:attachment":[{"href":"https:\/\/plexuk.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/plexuk.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/plexuk.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}