Symptoms of port exhaustion
Port exhaustion may be difficult to identify due to the many ways that it can manifest. The following list describes some of the common symptoms of port exhaustion:
Connections to the server fail. For example, you may see the following error:
Unable to connect to the remote server
System.Net.Sockets.SocketException: Only one usage of each socket address (protocol/network address/port) is normally permitted.
- Connections to the server time out.
- Performance is worse than expected.
- The server stops responding.
Determine if port exhaustion is the problem
To determine if these symptoms are caused by port exhaustion, you need to determine how many dynamic ports are in use. To do so, first identify the dynamic port range, and then view ports that are currently in use.
Identify the dynamic port range
Open a command prompt as an administrator, and run the following command to determine the dynamic port range:
netsh int ipv4 show dynamicportrange tcp
netsh int ipv6 show dynamicportrange tcp
The command displays the port number of the first dynamic port, also called the start port, and the number of ports.
Add the number of ports to the start port to determine the dynamic port range. For example, if the start port is 60000 and the number of ports is 5000, then the range is from 60000 through 65000.
For more information about the netsh command, see the Netsh Command Reference on Microsoft TechNet.
View ports currently in use
Run the following command to view the ports that are currently in use:
Tip: To send the output of the command to a file, enter the following command:
netstat –n > out.txt
Compare the ports that are currently in use to the dynamic port range. If most or all of the ports are in use, then it is likely that Tableau Server is experiencing port exhaustion. For more information on the output of the netstat command, see Troubleshoot port exhaustion issues on the Microsoft Support website.
The following image displays ports which are in the ESTABLISHED and TIME_WAIT states, that is, which are either in use for an active connection or which have not yet been released to the system for reuse. If the entire dynamic port range matches the image below, then Tableau Server is experiencing port exhaustion.