Standard Edition
-
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
The link says that Standard Edition supports up to 4 processors. Am I correct to assume that If I had 2 quad-core processors or 4 dual-core processors that this Edition would only be able to use 4 of the 8 processors available?
Is it based on available CPUs and not available cores?
Regards
Carl
-
it's physical processors that are counted, not cores...so you could have a 4 processor all with quad cores, as i remember it, and it would work with no problem
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Lowell is right. It's sockets, not cores. You'll get to use all your CPUs up to 4 CPUs, regardless of cores.
-
Sorry to sound dumb, but, if I buy SQL 2005 Standard Edition and I have 2 quad-core processors will it use all 8 cores? I guess thats what I really meant to ask first time around.
Carl
-
Steve and Lowell,
are you absolutely sure about that? I don't see anywhere in SQL that it differentiates between multiple cores and multiple CPU's. Which would indicate to me that it would only use the max allowed by your edition of SQL (i.e. 4 for standard).
As far as licensing cost goes you only pay per die, not per core, but I am not so sure this is true for how it works when you exceed the number of "CPUs" you are licensed for.
From my error log:
"Detected 4 CPUs. This is an informational message; no user action is required."
Nothing there tells me that this is 2 dies with 2 cores on each. Would love to be wrong on this though
-
here's one of many citations on it from microsoft: i just searched for sql 2005 server multi core processors and grabbed the first link
http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx
so to be clear, if you had that experimental IBM single CPU, with 16 cores on it, it will work with standard edition.
down below, where it talks about features:
Scalability and Performance Feature Express Workgroup Standard Enterprise Number of CPUs 1 2 4 No Limit *Includes support for multicore processors RAM 1 GB 3 GB O/S maximum O/S maximum 64-bit support WOW WOW Yes Yes Database size 4 GB No limit No limit No limit Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Not sure a link for MSDE vs Express is a good link, but..
I found this which indeed supports your claim:
http://www.microsoft.com/technet/technetmag/issues/2007/05/SQLQA/
Excerpt:
Q In addition to hyperthreading and dual-core technology, chip vendors are beginning to release processors with additional cores (four, eight, and more). I am considering purchasing a new server with multi-core processors to support a SQL Server 2005 Standard Edition deployment and am curious if, when using a four-core processor, I will only be able to make use of a single physical CPU (since Standard Edition is limited to four CPUs)?
A For the purposes of both licensing and CPU edition support, SQL Server considers only the number of physical sockets/CPUs, regardless of the number of cores on the processor. So, for example, the fact that SQL Server 2005 Standard Edition supports up to 4 CPUs means it will support 4 physical CPU sockets, regardless of the number of cores in each one (if you have 4 physical CPUs with 4 cores each, your Standard Edition deployment would have 16 logical CPUs to make use of). Moreover, even though you have 16 cores/logical CPUs, the licensing requires only that you pay for the 4 physical CPUs, not all 16 cores
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply