+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 34
MIS Systems Thread, SQL 2008 Licensing in Technical; Originally Posted by djm968 Would SQL 2008 Per Server Licensing and individual CALS not be a more cost effective option? ...
  1. #16

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Quote Originally Posted by djm968 View Post
    Would SQL 2008 Per Server Licensing and individual CALS not be a more cost effective option? How many users/devices need to connect to SIMS?
    Yes, how many users\devices would be connected anyway?

  2. #17
    Richie1972's Avatar
    Join Date
    Apr 2006
    Location
    Blackburn
    Posts
    239
    Thank Post
    2
    Thanked 6 Times in 6 Posts
    Rep Power
    19
    Enough to make the per processor option the best way - somewhere around 50-100 users

  3. #18

    Join Date
    Sep 2006
    Location
    Essex
    Posts
    786
    Thank Post
    1
    Thanked 34 Times in 32 Posts
    Rep Power
    24
    Well that depends on your current Microsoft Licensing model

    SQL 2008 School Agreement MVLS Pricing (approx)

    SQL Server 2008 R2 Standard - License - Schools £115.20
    SQL Client 2008 R2 Device CAL - Schools £21.60

    I make that just under £1200 for 50 devices or £2280 for 100 devices connecting to the SQL server and you can have as many Sockets, processors or cores in the VM as you like!

    Microsoft SQL Server 2008 R2 Standard | Microsoft | Products | ... discounted software for education establishments

  4. #19
    Richie1972's Avatar
    Join Date
    Apr 2006
    Location
    Blackburn
    Posts
    239
    Thank Post
    2
    Thanked 6 Times in 6 Posts
    Rep Power
    19
    Schools agreement is yearly payment, Select Agreement is one off.
    So, if I am right about the licensing on Hyper-V (which, from checking settings on physical and virtual servers, appears to be correct):
    1xSQL 2008 R2 Standard licence (1 CPU with 4 cores - which is how the Hyper-V client sees the CPU)=£942 one off payment
    and as many clients as I want

  5. #20

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    636
    Thank Post
    101
    Thanked 135 Times in 105 Posts
    Rep Power
    68
    You can limit the amount of cores used by SQL in the properties of the SQL Server Management studio.
    It's in the properties of the database engine for the instance you're running. I dont know whether simply limiting it there though means you need less licenses or whether it's completely irrelevant - but just to answer an earlier question.

    Mic@Serco

  6. #21

    Join Date
    Sep 2006
    Location
    Essex
    Posts
    786
    Thank Post
    1
    Thanked 34 Times in 32 Posts
    Rep Power
    24
    Somebody stopme! or correct me if i'm wrong but I see at as this!
    1 x SQL Server 2008 R2 Standard - License - SELECT £144.00 (one off payment) and as many clients as you want at £27

    This certainly seems to be the licensing model many local authorities are recommending.
    Last edited by djm968; 15th July 2010 at 02:02 PM. Reason: Update

  7. #22
    Richie1972's Avatar
    Join Date
    Apr 2006
    Location
    Blackburn
    Posts
    239
    Thank Post
    2
    Thanked 6 Times in 6 Posts
    Rep Power
    19
    Michael2K6: Yes, I thought there was a way to do that and, also yes, I'm not sure if it makes a difference to licencing (it should, if it's being restricted to 2 CPUs).
    I think, however, I may be right in my previous post about a Hyper-V guest having 4 virtual processors derived from a physical host with quad core CPUs being equal to the Hyper-V guest having a single quad core CPU - the MS docs seem to imply this

  8. #23

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    636
    Thank Post
    101
    Thanked 135 Times in 105 Posts
    Rep Power
    68
    Richie_OLSJ, i think you may be right. That would certainly make sense. I'm still not willing to commit to it being correct though lol.

  9. #24
    Richie1972's Avatar
    Join Date
    Apr 2006
    Location
    Blackburn
    Posts
    239
    Thank Post
    2
    Thanked 6 Times in 6 Posts
    Rep Power
    19
    Quote Originally Posted by djm968 View Post
    1 x SQL Server 2008 R2 Standard - License - SELECT £144.00 (one off payment) and as many clients as you want at £27
    Ok, looking at the Select pricing the £144 is for SQL 2008 R2 std which requires CALs, so what is the £27?

    If the £27 is for this: http://www.pcwb.co.uk/catalogue/item/C0009917 then that says it's just a single user CAL
    Last edited by Richie1972; 16th July 2010 at 09:13 AM.

  10. #25


    Join Date
    Feb 2007
    Location
    51.403651, -0.515458
    Posts
    9,806
    Thank Post
    262
    Thanked 2,967 Times in 2,182 Posts
    Rep Power
    846
    Quote Originally Posted by Richie_OLSJ View Post
    Ok, looking at the Select pricing the £144 is for SQL 2008 R2 std which requires CALs, so what is the £27?
    The £27 is the price for each CAL which would be required for every user (or device) accessing the SQL Server. It would therefore cost £2,844 if you had 100 users (£144 + (100 * £27)).

  11. #26

    Join Date
    Sep 2006
    Location
    Essex
    Posts
    786
    Thank Post
    1
    Thanked 34 Times in 32 Posts
    Rep Power
    24
    Educational Price for a single device or user CAL is around £27 and IMO the PC World link you provided is not the Academic SELECT price, or PC world are making a huge profit on the CALs.

    Before you commit to anything, I would call a few educational vendors and get their licensing specialist to do some leg work for you. They are usually very helpful and knowledgeable. I can personally recommend the licensing guys and girls at Pugh and Ramesys.
    (I am in no way connected to either of these companies and I am sure there are many others that provide a good a service.)

    Pugh SQL Server Pricing : Microsoft SQL Server 2008 R2 Standard | Microsoft | Products | ... discounted software for education establishments
    Ramesys SQL Server Pricing : Product Categories
    Last edited by djm968; 16th July 2010 at 09:53 AM. Reason: URL updates

  12. #27
    Richie1972's Avatar
    Join Date
    Apr 2006
    Location
    Blackburn
    Posts
    239
    Thank Post
    2
    Thanked 6 Times in 6 Posts
    Rep Power
    19
    djm968: The link I sent was for info on the product, not the price.
    If the Select price per user CAL is £27, then unless you've only got a few clients, the per processor SQL is the best option for a secondary school

  13. #28

    Join Date
    Sep 2006
    Location
    Essex
    Posts
    786
    Thank Post
    1
    Thanked 34 Times in 32 Posts
    Rep Power
    24
    Depends on what you define as a few.

    The cut-off point is around 70 clients for a “Single Socket” single processor multi-core physical server but this wouldn’t be the case for a virtual machine because as you have discovered, it will see each core as a separate virtual processor and reducing the number of virtual processors for your SQL VM will obviously have an impact on performance and you will therefore need buy four SQL 2008 processor licenses at just shy of a grand each!
    That’s why I suggest a SQL 2008 standard server license (supports 4 CPUs) and CALS may be the most cost effective licensing model for Virtual SQL Servers. Unless of course you have no idea how many clients or users are going to connect to the SQL server (through the firewall from the internet for example) then you have no choice and are forced to use the per processor model.

  14. #29
    Richie1972's Avatar
    Join Date
    Apr 2006
    Location
    Blackburn
    Posts
    239
    Thank Post
    2
    Thanked 6 Times in 6 Posts
    Rep Power
    19
    As I've already pointed out in earlier posts within this thread - it's not quite as simple as saying every virtual processor in a hyper-v client is treated as a physical processor.
    If you build a hyper-v client on a host with a quad core cpu and assign 4 virtual processors to the client, the client will have a single, quad core processor (if it's server 2008, check system properties or system information and it will report 4 core, 4 logical cpu just the same as the physical server).
    However, if you built your Hyper-V client on hardware with 2 dual core cpus and assigned 4 virtual processors to your client, it would report as having 2 dual core cpus.
    So, now I can buy a single processor SQL 2008 R2 Std licence and have as many clients as I like for £942 (approx.)

  15. #30

    Join Date
    Sep 2006
    Location
    Essex
    Posts
    786
    Thank Post
    1
    Thanked 34 Times in 32 Posts
    Rep Power
    24
    If you read my relpy carefully I think you will find that I did not say every physical CPU = vCPU - I was talking about cores and the relationship to vCPUs on a Hyper V client and how this may impact SQL licensing which I thought was the reason for the OP. IF and that is the question IF you can set the Hyper V client to show that it is only using one vCPU and are happy with the performance then a single proc SQL 2008 R2 Std license is all I would buy also.



SHARE:
+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. New SIMS Server - Windows 2008 R2 & SQL 2008 R2
    By MYK-IT in forum MIS Systems
    Replies: 23
    Last Post: 17th June 2010, 10:31 AM
  2. Windows 2008, SQL 2008 and Backup Exec 12
    By joe90bass in forum Windows
    Replies: 2
    Last Post: 5th May 2010, 03:49 PM
  3. MS 2008 R2 TS Licensing Query
    By stariq in forum Licensing Questions
    Replies: 15
    Last Post: 10th March 2010, 08:55 PM
  4. SQL Server Licensing
    By BatchFile in forum Wireless Networks
    Replies: 2
    Last Post: 24th April 2009, 04:17 PM
  5. 2008 licensing
    By ozydave in forum Windows Server 2008
    Replies: 3
    Last Post: 18th November 2008, 05:47 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •