Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2016
    Posts
    11

    Question Unanswered: How do I know the number of SQL Server licenses on my sql server?

    I've read on https://docs.microsoft.com/en-us/sql...y-transact-sql that SERVERPROPERTY('LicenseType') and SERVERPROPERTY('NumLicenses') are unused actually.

    So how can I discover on a SQL Server Enterprise or Standard instance how many licenses it's using?

    I need to know if my server is in compliance.

    Thank you.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,863
    Provided Answers: 17
    These days (since SQL 2012, I believe) Enterprise Edition is licensed only by core. You can get a Server license and CALs for Standard Edition, but I am not sure how even Microsoft determines compliance with that number.

  3. #3
    Join Date
    Jun 2016
    Posts
    11
    My situation is that i have four different sql servers, each one with enterprise or standard license (per core model).
    Each server has X CPU cores. Sql server requires X licenses on each server.
    I need to know this number of licenses per server to check if itīs in compliance. And other information is that if a server have like 10 cores with 10 sql licenses i need to check if itīs possible to downgrade to like 4 cores so i could release 6 licenses.

    Iīm searching on google but canīt find my answer.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,863
    Provided Answers: 17
    For core licenses, it is the number of cores on the box (excluding Hyperthreaded cores). The only way to downgrade the number of licensed cores is to remove cores from machines. Dev/Test/QA machines are usually covered under an MSDN license. Once core licenses have been bought, they can be divided up among boxes in almost any way. No SQL Instance can be licensed for less than 4 cores. The licensing datasheet can be found here:

    https://www.microsoft.com/en-us/sql-...r-2016-pricing

  5. #5
    Join Date
    Jun 2016
    Posts
    11
    MCrowley, is not posible for one to install a Standard License of SQL Server for 4 cores on a server that have 6 cores? It occurs and error? Otherwise i need to audit to find those servers with not compliance license instaled.

    And other question: Letīs assume that a server with 6 core have one license per core. If i downsize to 4 cores (removing 2 cores) how can i get this 2 core license so i can use on another server?
    Iīm trying to understand/see/verify this sql server licensing per core model in practice. The theory is already clear to me.

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,863
    Provided Answers: 17
    There is no error (in fact there is no check at all) when you install an instance of SQL Server on a machine with more cores than you are licensed for. Typically organizations will have to "true up" at the end of a year, or potentially get audited. How many cores you need can get a little complicated, especially if you are looking at clustered installs.

    You can get the (rough) number of cores you should be licensed for by querying the sys.dm_os_sys_info table, and adding up all the Hyperthread_ratio values. Like I say, this method will begin to break down when you get into Software Assurance, and Clustered installs.

  7. #7
    Join Date
    Jun 2016
    Posts
    11
    Thanks for your comments.

    Actually i work on the database team of the company and my boss put me in this task to audit the sql servers of the company that are standard or enterprise to check if the licenses are suitable for the number of cores of each one. And iīm trying to google but iīm not finding ways to discover this information.
    I have ways to check the number of cores of an server, i can see if it is standard or enterprise.
    But until now i didnīt find a serverīs sql license detail to see how many cores are licensed on that server.

    After getting this information about all sql servers the next step is to analyze if we can remove cores (on the case of VMs) to decrease the number of core licenses.
    And need to analyze the sql server versions to check when we will need to upgrade to the 2016 version.

    After doing some initial research i guess maybe i will have to contact some sql server specialist to help me out with this Sql Server Licenses project.

    What do you think? Am i losing something?

    Thanks.

  8. #8
    Join Date
    Jan 2017
    Posts
    18
    there are most of Del ear which is selling the SQL licence

  9. #9
    Join Date
    Jun 2016
    Posts
    11
    Quote Originally Posted by markfernando View Post
    there are most of Del ear which is selling the SQL licence
    Sorry, didnīt understand what youīve said. Most of del ear?

  10. #10
    Join Date
    Dec 2016
    Posts
    8
    According to me, you should contact with Microsoft for know the SQL license number as well as SQL dealer. you should contact with https://www.janbasktraining.com for SQL License number.

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
  •