November 22, 2011 at 11:48 am
I guess in real world for middle and big company, in most cases the server has at least 2 processors.
If we want to buy a Processor based SQL server license, and if we have 4 processors , then we need to pay the processor license X4, correct?
I just thought this becomes expensive with new computers with powerful multiple CPUs.
Thanks
November 22, 2011 at 11:54 am
What version are you buying?
Sql 2012 will charge by cores.
Before that it's by physical sockets.
So a quad proc, 10 cores processor would only require 4 licenses, in 2012 it's 40!
yes they are cheaper by the unit, but not THAT much!
November 22, 2011 at 11:55 am
You pay per socket, not per core/cpu.
IE: If you have a 16 core chip, it takes up 1 socket. You buy the license on the socket (1), not the core(16). It's one of the reasons the Total Cost of Ownership for SQL Server is so much lower than Oracle.
So a 64 core machine with 4 sockets costs you x4 licenses. ~5k for standard, ~25k for enterprise, each.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 22, 2011 at 11:56 am
Ninja's_RGR'us (11/22/2011)
What version are you buying?Sql 2012 will charge by cores.
Before that it's by physical sockets.
So a quad proc, 10 cores processor would only require 4 licenses, in 2012 it's 40!
yes they are cheaper by the unit, but not THAT much!
Wut? Gyeaddangit! That better be one heck of a price drop.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 22, 2011 at 12:00 pm
I am currently buying 2008 standard SQL server license.
Is there a way buy logging to the SQL server and found out how many sockets it has?
Thanks
November 22, 2011 at 12:05 pm
Evil Kraig F (11/22/2011)
Wut? Gyeaddangit! That better be one heck of a price drop.
Around about 1 socket === 4 cores in terms of price. Is complex, see Denny Cherry's blog for details.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2011 at 12:34 pm
GilaMonster (11/22/2011)
Evil Kraig F (11/22/2011)
Wut? Gyeaddangit! That better be one heck of a price drop.Around about 1 socket === 4 cores in terms of price. Is complex, see Denny Cherry's blog for details.
Thanks for the pointer. Found and read through it. This could get ugly. I have a feeling as a consultant I need to get VERY comfortable with SQL2k8R2 since that's going to be around for a looong time. Of course, I'm currently fighting to get out of 2k5, so, well, I guess that goes with the territory.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 22, 2011 at 1:54 pm
November 22, 2011 at 2:16 pm
okbangas (11/22/2011)
Ninja's_RGR'us (11/22/2011)
Sql 2012 will charge by cores.With a minimum of 4 cores per processor. So, if you have a dualcore CPU, you'll still pay for a quad core.
That said, if you have a dual-core processor in a server today, you should probably be thinking about a hardware upgrade anyway.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2011 at 2:23 pm
Evil Kraig F (11/22/2011)
Ninja's_RGR'us (11/22/2011)
What version are you buying?Sql 2012 will charge by cores.
Before that it's by physical sockets.
So a quad proc, 10 cores processor would only require 4 licenses, in 2012 it's 40!
yes they are cheaper by the unit, but not THAT much!
Wut? Gyeaddangit! That better be one heck of a price drop.
Take your current licence price and slash it in 4 (because they figured most cpus had 4 cores)
November 22, 2011 at 2:51 pm
Evil Kraig F (11/22/2011)
I have a feeling as a consultant I need to get VERY comfortable with SQL2k8R2 since that's going to be around for a looong time. Of course, I'm currently fighting to get out of 2k5, so, well, I guess that goes with the territory.
Personally I don't think so. With quad core processors the price is unchanged from R2. If on higher cores and with an enterprise agreement, the MS rep can convert at a more favourable ratio.
Licensing for virtuals is now a hell of a lot easier. Before, say I have a virtual server with 6 virtual CPUs. How many socket licenses do I need (assuming I'm licensing the virtual not the host)? Now it's clear.
Got a client currently on 2005, I explained how the licenses for 2012 work and they're considering moving to 2012 and from Standard to Enterprise.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2011 at 3:11 pm
Licensing for virtuals is now a hell of a lot easier. Before, say I have a virtual server with 6 virtual CPUs. How many socket licenses do I need (assuming I'm licensing the virtual not the host)? Now it's clear.
Sorry if this is a stupid question, so if 6 vitual CPUs, we need six core license?
November 22, 2011 at 3:17 pm
sqlfriends (11/22/2011)
Licensing for virtuals is now a hell of a lot easier. Before, say I have a virtual server with 6 virtual CPUs. How many socket licenses do I need (assuming I'm licensing the virtual not the host)? Now it's clear.
Sorry if this is a stupid question, so if 6 vitual CPUs, we need six core license?
Yep, well, 3 '2 core' packages, since you can only buy them as twins.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 22, 2011 at 3:20 pm
GilaMonster (11/22/2011)
Licensing for virtuals is now a hell of a lot easier. Before, say I have a virtual server with 6 virtual CPUs. How many socket licenses do I need (assuming I'm licensing the virtual not the host)? Now it's clear.
This may have to do with patterns of implementations. Most places I've worked at, when using virtual farms, have been licensing the hosts in the virtual farms so that the servers can move at whim.
I personally still prefer hard machines however. There's so many things in virtual land that can go badly (non raw storage, throttle bottlenecking in the rack, etc) that they make me cringe except for things like dedicated vendor instances and very small implementations.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply