August 1, 2012 at 1:56 am
Hi all
Does anyone know if its possible to limit the number of cores available to SQL, I know you can do affinity for physical CPU but with the new licensing model its incredibly expensive to even license a standard edition of SQL at the moment and I was wondering if this was a way round it?
Thanks
August 1, 2012 at 1:58 am
You have to disable them in the BIOS, at least for SQL 2008. If the processor is visible to windows, it has to be licensed (SQL). That's the 2008 rules, don't know for sure about the 2012. Contact MS licensing.
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
August 1, 2012 at 2:04 am
OK thanks Gail, we have fired something off to our account manager but I sometimes find different companies get different answers, was just after some real world experiences which you have given.
August 1, 2012 at 2:08 am
Kwisatz78 (8/1/2012)
OK thanks Gail, we have fired something off to our account manager but I sometimes find different companies get different answers, was just after some real world experiences which you have given.
You will get whatever answer the Licensing "specialist" thinks will generate the most cash.
We had a licensing rep once say that a customer should buy enterprise over standard as standard only supports 32 databases per instance and so and enterprise supports many more. This came from a Microsoft Licensing Specialist!
Double check whatever answer you get.
August 1, 2012 at 2:08 am
I am not a licensing expert. Do not take what I say as the absolute truth without verifying with MS licensing (preferably in writing so you have a record)
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply