5

SQL Server licensing, is it per CPU? If yes, so a 32 CPU would mean like 150K in licensing?

splattne
  • 28,348
  • 19
  • 97
  • 147
user2659
  • 1,152
  • 4
  • 20
  • 32
  • 2
    It used to be per socket, but with SQL 2012 it all changes once again. http://itknowledgeexchange.techtarget.com/sql-server/sql-server-2012-licensing-changes/ – mrdenny Nov 08 '11 at 08:32
  • The answer is yes, but a 32 SOCKET server is going to set you back by more than a million likiely, so - sorry, the 150k do not make a difference. – TomTom Nov 08 '11 at 08:46

6 Answers6

10

I'm sure you're all aware of it, but just for the record the per-CPU pricing for SQL Server is per socket - not per core.

Joel Mansford
  • 985
  • 1
  • 5
  • 13
  • As of SQL 2017 I believe it is per core now, which makes it very expensive for that 32 core example. – jjxtra Jul 31 '19 at 16:11
8

There are a few licensing options.

  1. If the application is internal only you can license the SQL Server with a server license which is a few thousand, then buy a CAL one for each employee which needs access to the system.

  2. If the application is internal only you can license the SQL Server with a server license which is a few thousand, then buy a CAL one for each device which needs access to the system.

  3. If the application is internet facing, or the cost of the CALs is more than the cost of CPU licenses you can get CPU licenses. They are ~$8k for Standard Edition and $~25k for Enterprise Edition. These licenses are per physical CPU, no matter how many cores there are per physical CPU.

To use more than 4 physical CPUs you'll need the Enterprise Edition as the standard edition only supports 4 physical CPUs. So a server with 32 physical CPUs would come in at about $800k to license. If you have a 8 CPU server with 4 cores per server then the licenses will cost you about $200k.

All of these numbers assume that you are paying retail pricing. With a purchase this big you'll want to look into a Microsoft Volume License Agreement which will drop the price quite a bit. We are level A (the smallest discount) and we saved ~8-10% off the cost of the licenses we bought. If you got up to level D (the level is decided by the number of points the software you are buying to worth) the discount would be much more.

mrdenny
  • 27,074
  • 4
  • 40
  • 68
  • so according to this post, he spend 800k?? http://plentyoffish.wordpress.com/2009/06/14/upgrades-themes-date-night/ "HP ProLiant DL785 with 512 GB of ram and 32 CPU’s and moved from SQLserver 2005 to 2008 and windows 2008. " – user2659 Jun 20 '09 at 04:26
  • You can always go for SPLA to turn it into a monthly cost, instead of having a massive one-off hit – Nick Kavadias Jun 20 '09 at 05:39
  • 3
    800K? Go and get the price for an 32 CPU Oracle license... – gbn Jun 20 '09 at 06:46
  • The SPLA only applies when you are a hosting provider such as Rackspace where you are renting the server to another company. If your company will be running it's own service on the server you aren't eligebale for the SPLA on that server. – mrdenny Jun 20 '09 at 20:09
  • not true. You are also elegible for SPLA if you are offering the server for example to run an online service where people rent access to the service. StackOverflow, for example, can run it all via SPLA. – TomTom Nov 08 '11 at 06:23
  • StackOverflow doesn't rent services to anyone. They give them away for free collecting ad revenue for the site. SPLA is very specific about who can "resell" an SPLA license. As SPLA stands for Service Provider License Agreement you have to be a service provider to be eligible. SPLA is for companies to basically rent licenses to other companies as part of a service offering. The basic info about SPLA can be found at http://www.microsoft.com/hosting/en/us/licensing/splabenefits.aspx. – mrdenny Nov 08 '11 at 08:30
3

Here's the link to the Microsoft page that discusses SQL Server licensing and all the options - it also has a link to a doc that explains the various options and the gray areas.

This is the official word: SQL Server 2008 Pricing or SQL Server 2005 Pricing. Depending on your company size and agreements with MS, you may be able to negotiate lower volume rates.

Hope this helps.

PS Google is your friend - these are the top hits for 'SQL Server 2008 pricing'

Paul Randal
  • 7,184
  • 1
  • 35
  • 45
2

At that price, go talk to your local microsoft office and do a deal.

DDM
  • 240
  • 2
  • 12
1

When it comes to per CPU licensing, it is probably better to think of it as per socket. If you have a single, quad core processor (which sits in a single socket, of course), you will only pay for a single CPU license.

So, say you had 32 CPU's spread out over 4 sockets (4x quad core procs), your total cost would be around $64K (32 / 4 * $8K).

Hope that makes things a little more clear!

Michael Gorsuch
  • 2,358
  • 1
  • 21
  • 24
-2

One other consideration - you only have to pay per User licensing fees if your users are connecting directly to the database. If they connect to a website that connects to your database, then you don't a CAL per user.

Beep beep
  • 1,843
  • 2
  • 18
  • 33
  • 1
    This is wrong. If the website users are external to your company, an external connector license is required; if they are internal, one CAL per user or one CAL per device is required (except in the case of per-proc licensing). Microsoft license agreements specifically state that the kind of connection multiplexing suggested by this answer do not relieve the customer of purchasing CALs for each end-user or machine. – Jay Michaud Jun 21 '09 at 00:08
  • 1
    Lindy is very wrong as Jay stated, but Jay's comment was slightly incorrectly written, so I'll comment here. If you have a CPU license you don't need CALs. If your using CALs you need one for every end user or end device which gets it data from the SQL Server. It doesn't matter how many layers of middle ware (ie. web servers) there are between the end user/device and the SQL Server they must still have a CAL. The only exception to this is if you have CPU licensing. The external connector allows users to connect to web servers without Windows CALs. – mrdenny Jun 22 '09 at 01:34