Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 dual six core proc, SQL only shows 8

Author  Topic 

w2pac12345
Starting Member

2 Posts

Posted - 2012-07-03 : 12:09:21
We have 2 six core processors however in management studio when I go to properties and click on processors it only shows processors 0-7. It should be showing 0-11. Any ideas?

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-07-03 : 13:54:04
quote:
Originally posted by w2pac12345

We have 2 six core processors however in management studio when I go to properties and click on processors it only shows processors 0-7. It should be showing 0-11. Any ideas?

What edition of SQL Server 2008 are you using? See this page that describes the compute capacity of the different editions. From what you described it seems like you should be able to use 12 cores, but take a look at that page to see if that helps at all.
Go to Top of Page

w2pac12345
Starting Member

2 Posts

Posted - 2012-07-03 : 13:58:39
We have 2008 SQL. Looks like it is a BIOS issue as device manager shows only 8 cores and not 12. I know this isnt an SQL question now but any idea how to get Server 2008 R2 SP1 to recognize all 12 cores instead of 8.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-07-04 : 01:51:13
Potentially a BIOS issue. Consider updating the BIOS. Is your BIOS displaying everything properly?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -