How to find cores and logical processors in SQL Server
See the answer to this question.

It quotes https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms143760(v=sql.105)


  SQL Server supports the specified number of processor sockets
  multiplied by the number of logical CPUs in each socket. For example,
  the following is considered a single processor for purposes of this
  table: A single-core, hyper-threaded processor with 2 logical CPUs per
  socket. A dual-core processor with 2 logical CPUs. A quad-core
  processor with 4 logical CPUs. SQL Server is licensed per processor
  socket, and not per logical CPU basis.