將 TCP/IP 連接埠對應到 NUMA 節點 (SQL Server)Map TCP IP Ports to NUMA Nodes (SQL Server)

適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions) 適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions)

此主題描述如何使用 SQL ServerSQL Server 組態管理員,將 TCP/IP 通訊埠對應到非統一記憶體存取 (NUMA) 節點。This topic describes how to map TCP/IP ports to non-uniform memory access (NUMA) nodes by using SQL ServerSQL Server Configuration Manager. 在啟動時, Database EngineDatabase Engine 會將節點資訊寫入錯誤記錄檔。On startup, the Database EngineDatabase Engine writes the node information to the error log.

若要判斷您想要使用之節點的節點號碼,請從錯誤記錄檔或從 sys.dm_os_schedulers 檢視中讀取節點資訊。To determine the node number of the node you want to use, either read the node information from the error log, or from the sys.dm_os_schedulers view. 若要將 TCP/IP 位址和通訊埠設為單一或多重節點,請在通訊埠編號後面用方括號附加節點識別點陣圖 (相似性遮罩)。To set a TCP/IP address and port to single or multiple nodes, append a node identification bitmap (an affinity mask) in brackets after the port number. 可以用十進位或十六進位格式指定節點。Nodes can be specified in either decimal or hexadecimal format. 若要建立點陣圖,請由零開始,將節點從右到左編號,例如 76543210。To create the bitmap, first number the nodes from right to left starting with zero, as in 76543210. 建立節點清單的二進位表示法,以 1 代表您要使用的節點,以 0 代表您不要使用的節點。Create a binary representation of the node list, providing 1 for nodes you want to use, and 0 for nodes you do not want to use. 例如,若要使用 NUMA 節點 0、2 和 5,請指定 00100101。For example, to use NUMA nodes 0, 2, and 5, specify 00100101.

NUMA node number                            76543210
Mask for 0, 2, and 5 counting from right    00100101

將二進位表示法 (00100101) 轉換成十進位 [37]或十六進位 [0x25]Convert the binary representation (00100101), into decimal [37], or hexadecimal [0x25]. 若要接聽所有節點,則不要提供節點識別碼。To listen on all nodes, provide no node identifier.

如果通訊埠對應到不止一個 NUMA 節點, SQL ServerSQL Server 會以循環方式指派節點的連接,而不會嘗試去平衡節點的負載。If a port is mapped to more than one NUMA node, SQL ServerSQL Server assigns connections to nodes in a round-robin fashion without attempting to balance load across the nodes.

注意

若要讓 SQL ServerSQL Server 能夠在每個 IP 位址的多個 TCP 通訊埠上接聽,請參閱 設定 Database Engine 接聽多個 TCP 通訊埠To enable SQL ServerSQL Server to listen on multiple TCP ports for each IP address, see Configure the Database Engine to Listen on Multiple TCP Ports.

使用 SQL Server 組態管理員Using SQL Server Configuration Manager

若要將 TCP/IP 通訊埠對應到 NUMA 節點To map a TCP/IP port to a NUMA node

  1. SQL ServerSQL Server 組態管理員中,展開 [SQL Server 網路組態],然後按一下 [ <instance name> 的通訊協定]。In SQL ServerSQL Server Configuration Manager, expand SQL Server Network Configuration, and then click Protocols for <instance name>.

  2. 在詳細資料窗格中,按兩下 [TCP/IP]。In the details pane, double-click TCP/IP.

  3. [IP 位址] 索引標籤上,在對應到要設定之 IP 位址的區段中,在 [TCP 通訊埠] 方塊中,在通訊埠編號後面以方括號加入 NUMA 節點識別碼中。On the IP Addresses tab, in the section corresponding to the IP address to configure, in the TCP Port box, add the NUMA node identifier in brackets after the port number. 例如,對於 TCP 通訊埠 1500 和節點 0、2 和 5,請使用 1500[37]1500[0x25]For example, for TCP port 1500 and nodes 0, 2, and 5, use 1500[37], or 1500[0x25].

另請參閱See Also

軟體 NUMA (SQL Server)Soft-NUMA (SQL Server)