I have a web server (Windows Server 2003 in DMZ) that uses JDBC to connect to an Informix database (runs on Windows Server 2012 on a local network).
After migrating the web server to Windows Server 2012, database connections are very slow. If I analyze network traffic on the database server, then between PSH, ACK and ACK sent from the web server, it expires after 0.5 seconds (see My Wireshark log at the end). If I compare this to the log when connecting from the old web server, I do not see these 0.5 seconds.
Can someone help me find out if these 0.5 seconds are needed for the database to query my SQL and response. Or is it a delay of 0.5 seconds from the network. If this seems like a network issue, do you have any tips for further testing? (By itself, I do not have access to other network components between the web server and the database server. I can only provide rare information about the infrastructure and know almost nothing about networks).
What I tested so far:
- disable windows firewall on both servers
- disable IPv6 on the web server
- shut down the old web server and switch the IP address of the new web server to the IP address of the old one.
- disable Windows autoconfiguration on the web server (netsh interface tcp set global autoconfiguration = disabled)
See my Wireshark magazine here: Wireshark Magazine