Home > IT Answers > DataCenter > SQL 2008 R2 CPU Count
LeeHerr
15 pts.
 SQL 2008 R2 CPU Count
CPU usage, Intel Xeon, SQL 2008, SQL Server 2008, SQL Server 2008 R2
The SQL 2008 R2 Std specification says it can use up to 4 cpus.  If I have two quad-core xeon processors.  Would this count as 8 or 2?

Software/Hardware used:
MS SQL 2008 R2 Standard
ASKED: August 31, 2010  5:55 PM
UPDATED: September 2, 2010  12:53 AM
RELATED QUESTIONS
Answer Wiki:
That counts as 2. Microsoft counts sockets not cores.
Last Wiki Answer Submitted:  August 31, 2010  7:48 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Will SQL 2008 R2 scale to use only 2 cores of a 4 core processor?

LeeHerr
 15 pts.
 

I understood that this would only count as one. Since one socket (processor) has four cores, and SQL Server will only use up to 4 cores, only one socket would be needed for licensing purposes. This area is very confusing in their literature, and their virtualization paper doesn’t necessarily clear it up:
http://download.microsoft.com/download/6/8/9/68964284-864d-4a6d-aed9-f2c1f8f23e14/virtualization_whitepaper.doc

Kccrosser
 3,830 pts.