I am trying to troubleshoot periodic drops between the Ignition client and the gateway. The client machine and server are on the same switch. My guess is that it is a socket issue but I do not know how to view the number of sockets in use. Is there a way to see how many sockets are in use for SQL and Ignition?
ERROR 3:46:44 PM Weld Database connection FAULTED.
com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host localhost, named instance MSSQLSERVER has failed. Error: “java.net.SocketTimeoutException: Receive timed out”. Verify the server and instance names, check that no firewall is blocking UDP traffic to port 1434, and for SQL Server 2005 or later verify that the SQL Server Browser Service is running on the host.