I understand the basic concept of max dop and cost threshold.
I am reviewing 3 SQL servers (virtualized, not physical machines) with the following combinations of socket and virtual processor:
1 socket 2 virtual processors
12 sockets 24 virtual processors
24 sockets 24 virtual processors
The max dop is 0 and cost threshold is 5.
I am reading the recommendation from the above link and they have used terms like logical processor, NUMA node. Where as when I open the task manager I can see number of sockets and virtual processors.
Starting with SQL Server 2016 (13.x), during service startup if the Database Engine detects more than eight physical cores per NUMA node or socket at startup, soft-NUMA nodes are created automatically by default.
I understand that Soft NUMA means that - it creates software based NUMA so that cores can be shared with multiple sockets.
Does NUMA node and socket mean the same thing?
In my examples, does the server configuration (see table from the above link) classify as single NUMA node or multiple NUMA nodes? If NUMA and socket is the same thing then I assume answer is multiple NUMA nodes?
Does physical core also mean virtual processor?