+ Post New Thread
Results 1 to 10 of 10
Licensing Questions Thread, [Windows Software] SQL Server CPU Licening in virtualised environment in Technical; Hi there, I am just trying to confirm whether we are covered on our SQL server licences. We have purchased ...
  1. #1

    Join Date
    Mar 2007
    Location
    Liverpool, UK
    Posts
    89
    Thank Post
    3
    Thanked 6 Times in 4 Posts
    Rep Power
    17

    [Windows Software] SQL Server CPU Licening in virtualised environment

    Hi there,

    I am just trying to confirm whether we are covered on our SQL server licences.

    We have purchased 6 x 1 cpu editions of sql 2005 standard edition licences a while ago when we were running 3 physical servers with 2 CPUs in each. These servers have since been decomissioned and are no longer in use.

    We have since implemented a virtual solution running across 3 host machines with 2 physical CPUs in each host. As we have enough sql server licences to cover all the physical CPUs across all host machines are we able to deploy 'as many' SQL servers as we need across all these host machines.

    Thanks

  2. Thanks to fox1977 from:

    albertwt (24th February 2010)

  3. #2

    Join Date
    Jan 2009
    Location
    England
    Posts
    1,406
    Thank Post
    306
    Thanked 307 Times in 265 Posts
    Rep Power
    82
    According to http://download.microsoft.com/downlo...w%20final.docx each Virtual CPU that you assign your VMs that are running SQL server requires an SQL license.

    It's a shame it doesn't work like the OS licensing!

  4. Thanks to Soulfish from:

    tmcd35 (25th February 2010)

  5. #3

    Join Date
    Mar 2007
    Location
    Liverpool, UK
    Posts
    89
    Thank Post
    3
    Thanked 6 Times in 4 Posts
    Rep Power
    17
    Hi there,

    Just an update. I have just spoken to Microsoft Licencing in the UK. They have confirmed that we have the appropriate licences.

    They confirmed that as we have the appropriate CPU licences (SQL 2005 standard) across all hosts we are able to run multiple/unlimited versions of SQL. Of course i am still awaiting written confirmation of the this from sql.

    I am not too sure if MS have changed their licencing agreements as a lot of stuff on the internet confirms the previous post.

    I will wait until i have it in blood from MS!

  6. #4

    Join Date
    Jan 2009
    Location
    England
    Posts
    1,406
    Thank Post
    306
    Thanked 307 Times in 265 Posts
    Rep Power
    82
    Quote Originally Posted by fox1977 View Post
    Hi there,

    Just an update. I have just spoken to Microsoft Licencing in the UK. They have confirmed that we have the appropriate licences.

    They confirmed that as we have the appropriate CPU licences (SQL 2005 standard) across all hosts we are able to run multiple/unlimited versions of SQL. Of course i am still awaiting written confirmation of the this from sql.

    I am not too sure if MS have changed their licencing agreements as a lot of stuff on the internet confirms the previous post.

    I will wait until i have it in blood from MS!
    Wouldn't surprise me if MS licensing has different information or a different interpretation to the MS document I linked to earlier. MS licensing is so complicated that every time you speak to a "licensing expert" you get a different answer

  7. #5

    Join Date
    May 2009
    Location
    Sydney
    Posts
    282
    Thank Post
    322
    Thanked 3 Times in 3 Posts
    Rep Power
    12
    cmiiw, SQL Server (whatever the edition) is always licensed per CPU sockets ?
    so if we assigned 4vCPU into this VM do we only pay for the physical CPU sockets ?

  8. #6
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,505
    Thank Post
    10
    Thanked 508 Times in 445 Posts
    Rep Power
    116
    Quote Originally Posted by albertwt View Post
    cmiiw, SQL Server (whatever the edition) is always licensed per CPU sockets ?
    so if we assigned 4vCPU into this VM do we only pay for the physical CPU sockets ?
    SQL 2008 has very different licensing to 2005. With enterprise you can SQL in as many VMs as the hardware supports as long as the host is licensed.

    The MS guide is here http://download.microsoft.com/downlo...nsingGuide.pdf


    It's a bit confusing as hyper-threading also has to be accounted for.

  9. 2 Thanks to DMcCoy:

    albertwt (24th February 2010), tmcd35 (25th February 2010)

  10. #7

    Join Date
    May 2009
    Location
    Sydney
    Posts
    282
    Thank Post
    322
    Thanked 3 Times in 3 Posts
    Rep Power
    12
    Quote Originally Posted by DMcCoy View Post
    SQL 2008 has very different licensing to 2005. With enterprise you can SQL in as many VMs as the hardware supports as long as the host is licensed.

    The MS guide is here http://download.microsoft.com/downlo...nsingGuide.pdf


    It's a bit confusing as hyper-threading also has to be accounted for.
    Thanks Mr. McCoy,

    in my ESXi the Hyper threading is turned off.

    Cheers.

  11. #8
    Richfrombechtle's Avatar
    Join Date
    Feb 2010
    Posts
    16
    Thank Post
    0
    Thanked 9 Times in 8 Posts
    Rep Power
    11

    SQL VM's

    The rule is:

    Number of Virtual CPU's / Number of Physical cores = No. of CPU licences (rounded up)

    If Hyper Threading is on then it becomes:

    Number of Virtual CPU's / Number of threads = No. of CPU licences (rounded up)

    Cheers
    Rich

  12. Thanks to Richfrombechtle from:

    albertwt (24th February 2010)

  13. #9

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,447
    Thank Post
    1,537
    Thanked 1,069 Times in 934 Posts
    Rep Power
    305
    Quote Originally Posted by DMcCoy View Post
    SQL 2008 has very different licensing to 2005. With enterprise you can SQL in as many VMs as the hardware supports as long as the host is licensed.

    The MS guide is here http://download.microsoft.com/downlo...nsingGuide.pdf


    It's a bit confusing as hyper-threading also has to be accounted for.
    OMG a 63 book on how to licence SQL 2008 Keeping my SQL box un-virtualised looks more and more attractive every day!

  14. #10

    Join Date
    May 2009
    Location
    Sydney
    Posts
    282
    Thank Post
    322
    Thanked 3 Times in 3 Posts
    Rep Power
    12
    Quote Originally Posted by Richfrombechtle View Post
    The rule is:

    Number of Virtual CPU's / Number of Physical cores = No. of CPU licences (rounded up)

    If Hyper Threading is on then it becomes:

    Number of Virtual CPU's / Number of threads = No. of CPU licences (rounded up)

    Cheers
    Rich
    Thanks mate !



SHARE:
+ Post New Thread

Similar Threads

  1. Software For New windows 2008 R2 Server Setup
    By sfoord in forum Windows Server 2008 R2
    Replies: 4
    Last Post: 2nd November 2009, 10:53 PM
  2. SIMS/SQL CPU core utilisation
    By meastaugh1 in forum MIS Systems
    Replies: 1
    Last Post: 27th July 2009, 11:56 AM
  3. Turn Off Updates for Smart Software in Domain Environment
    By euclid47 in forum Educational Software
    Replies: 8
    Last Post: 7th July 2009, 12:12 AM
  4. sims.net SQL Server CPU Spike
    By itgeek in forum MIS Systems
    Replies: 6
    Last Post: 26th February 2009, 01:28 PM
  5. Windows 2000 server & software deployment
    By iSteve in forum How do you do....it?
    Replies: 5
    Last Post: 18th April 2007, 09:25 AM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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