sql server detects 4 CPU on 8 installed

• joujousagem2006 1602

  SSCommitted

  Points: 1779

  More actions

  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 
  

• andreas.kreuzberg

  SSCertifiable

  Points: 6202

  More actions

  May 4, 2018 at 5:57 am

  #1989251

  Hi,
  if you use standard edition:

  Standard

  Limited to lesser of 4 Sockets or 16 cores

  Limited 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

• frederico_fonseca

  SSCoach

  Points: 16225

  More actions

  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

• e4d4

  SSCertifiable

  Points: 5777

  More actions

  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.