Post reply

sql server detects 4 CPU on 8 installed

  • May 4, 2018 at 5:07 am

    #330681

    Hello everyone
    I have a server 
    installed with windows server 2012 standart edition with sql server 2014 standart edition 64 bit
    I increase the number of VCPU on this server from 4 to 8 VCPUif I look at sql server side I see that it detects only 4CPU
    Who has idea how I can settle this?
    Thanks 

  • May 4, 2018 at 5:57 am

    #1989251

    Hi,
    if you use standard edition:

    StandardLimited to lesser of 4 Sockets or 16 coresLimited to lesser of 4 Sockets or 16 cores

    https://msdn.microsoft.com/en-us/library/ms143760%28v=sql.120%29.aspx?f=255&MSPPError=-2147217396

    This could be your problem.
    Best regards,
    Andreas

  • May 4, 2018 at 4:50 pm

    #1989367

    instead of presenting 8 vcpu with 1 core each present less vcpu with more cores. that will sort the licensing limit

  • May 5, 2018 at 10:41 am

    #1989391

    A little strange behavior because Task Manager show 2 sockets :/
    Look in error log for this information eg. SQL Server detected 1 sockets with 2 cores per socket and 2 logical processors per socket, 2 total logical processors; using 2 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
    this entry shows just after instance restart.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply