HP ProLiant DL980 G7 Server - Manual (Page 62)

1. Click the white check box (under Enable IP) of the port to be affinitized, as is shown in
Figure 52 (page 62) . This port must have a valid IP address or be classified as “IPAll”. An
invalid address cannot be assigned port affinity. An address with the first two bytes being
169 and 254 (169.254.n.n) is invalid and cannot be used for assigning ports. (On any
server running Microsoft Windows, a failure to obtain a dynamic IP address for the local
network interface from a DHCP server results in the network interface being assigned a local
Automatic Private IP Addressing [APIPA] IP address within the range 169.254.0.1 to
169.254.255.254. Such APIPA addresses are generally useful only for home or small intranet
LANs; they cannot be used to communicate with other nodes and devices in the network of a
production environment.)
Figure 52 Adding a port: select unique port number
2. Click Add Port.
3. Specify the unique port number. Optionally, set the NUMA node affinity mask by checking
the appropriate node numbers (0 through 7). In
Figure 52 (page 62) , the user specified port
number 1434 with node affinity mask 0 (every scheduler in a node is affinitized to its own
CPU), and port 4367 with node affinity mask 2 (every scheduler affinitized to node 2 CPU).
To explain further, the NUMA node affinity masks (0 through 7) form a bitmap, with mask
values 0 to 7 being the binary position place holders (ordered from right to left). If mask 0 is
checked, the decimal value is 1; if mask 1 is checked, the decimal value is 2; if mask 2 is
checked, the decimal value is 4, and so on. For example, for port 4367, mask 2 represents
2²=4 decimal. When mapping a TCP/IP port to a NUMA node in SQL Server Configuration
Manager, use notation such as IPA11:4367[4]). You can assign multiple nodes to the port,
adding the decimal values for each node mask selected. As another example, if node masks
0, 2, and 3 had been selected, the designation would be 4367[13], where 13 is 2°+ 2² +
2³ (note that 2°=1). Use the decimal number total (such as 13) to map a TCP/IP port to the
appropriate NUMA nodes.
4. To apply modifications, click Set (next to the instance name, above the IP address).
To delete a specific network port (if no ports have an affinity setting, the Delete Port feature is not
available), follow these steps:
1.
For the port you want to delete, click Delete Port.
2. To apply the change (deletion), click Set.
To delete all affinitized ports for a particular IP address, click Delete Port one by one for each of
the affinitized ports, then click Set to apply the changes.
NOTE: To enable your changes to take effect, follow HP ESO instructions for restarting SQL
Server instances or the system.
Receive-Side Scaling
Receive-Side Scaling (RSS) resolves the single-processor bottleneck by allowing the receive-side
network load from a network adapter to be shared across multiple processors. RSS enables packet
receive processing to scale with the number of available processors. This allows the Windows
Networking subsystem to take advantage of multi-core processor architecture.
RSS is supported by Windows Server 2008, Windows Server 2008 R2, and Windows Server
2012. RSS is enabled by default in Windows Server 2008 and Windows Server 2012. To take
advantage of RSS, network drivers must be written with RSS capabilities. With Windows 2008
62 Using HP ESO