0

This question already has an answer here:

I can see 4 processors when i right click on SQL server instance -> properties->General->Processors,

does it mean is the server had 2 core processor or 4 core processor? what is CORE? where do i check how many cores sql server has?

Very much appreciate your replies

marked as duplicate by Erik Darling sql-server Aug 29 '18 at 20:25

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1

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.

Not the answer you're looking for? Browse other questions tagged or ask your own question.