locked
SQL Server 2008 Express RRS feed

  • Question

  • Microsoft SBS 2008 includes SQL Server 2008 Express edition.  According to what I have been able to determine from Microsoft's documentation, SQL 2008 Express is limited to one cpu.  Does this mean one core of a quad-processor such as an Intel Xeon 5640 or will SQL 2008 Express take advantage of all 4 cores?
    Wednesday, November 24, 2010 9:19 PM

Answers

  • SQL Server express will  take advantage of all 4 cores in case of a quad core CPU. 1 CPU limitation for SQL express is for a single physical processor (socket), in case of a multi core cpu all cores will be used.

    Reference:

    http://support.microsoft.com/kb/914278

    • Edited by Chirag Shah Wednesday, November 24, 2010 9:57 PM typo
    • Proposed as answer by Naomi N Thursday, November 25, 2010 12:17 AM
    • Marked as answer by Tom Li - MSFT Sunday, December 5, 2010 1:35 PM
    Wednesday, November 24, 2010 9:56 PM