Sample Header Ad - 728x90

Is socket a synonym of NUMA, and virtual processor synonym of physical processor in a virtualized SQL server environment?

0 votes
2 answers
485 views
Link: https://learn.microsoft.com/en-US/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-ver15#Recommendations 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. 1 socket 2 virtual processors 2. 12 sockets 24 virtual processors 3. 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. Questions: 1. Does NUMA node and socket mean the same thing? 2. 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? 3. Does physical core also mean virtual processor?
Asked by variable (3590 rep)
May 5, 2022, 12:08 PM
Last activity: Jul 18, 2024, 05:21 PM