SQL Server Performance

SQL License Mode

Discussion in 'T-SQL Performance Tuning for Developers' started by LanLan, Jan 17, 2006.

  1. LanLan New Member

    Any one knows how to check the licenses mode on SQL, per processes or per seat ? I want to document the system.
  2. ghemant Moderator

    Hi,<br />you can do it with serverproperty('') read BOL for more.<br /><br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
  3. LanLan New Member

    Hello ghemant,

    Take one of our SQL box for example, I know it is per seat. Running the following script on SQL box, QA,

    select serverproperty('LicenseType')
    select serverproperty('NumLicenses')

    results are as follows:-
    DISABLED
    Null

    So, I think there must be somewhere else to grab the information.

    thanks, Lan
  4. ghemant Moderator

  5. LanLan New Member

    Hello ghemant,

    I run the following scripts on the SQL box:

    SELECT CONVERT(char(20), SERVERPROPERTY('Edition'))
    SELECT CONVERT(char(20), SERVERPROPERTY('NumLicenses'))
    SELECT CONVERT(char(20), SERVERPROPERTY('LicenseType'))

    Results:-
    Standard Edition
    Null
    Disabled

    Still not right.
  6. satya Moderator

    Meaning that licensing is disabled on this server. I'm not sure but it's possible this setting is invoked if you have selected Per Processor licensing, but then selected 0 processors. It could also have been done explicitly by someone.

    You should still be able to check on your licensing settings on the server. Open the server Control Panel and click on the SQL Server 2000 Licensing set up icon (not to be confused with the regular Windows Licensing icon). You cannot change licensing modes from here, but you can add or remove processors from your licensing set up.

    Refer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;291332 for relevant information.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  7. LanLan New Member

    thanks for all. I decide to manully check the mode :-(
  8. rohit2900 Member

    Hello Satya,
    The link you provided is for 2000..... from where I can configure the licencing for the sql server 2005 .....
  9. satya Moderator

Share This Page