We have a design software Aveva that we are having performance problems pulling up and instrument panel or valve panel after we add a symbol on the drawing. the software is installed on the workstation - 192.1.1.1 and it talks to the sql server - 192.1.1.2. I'm seening like between 5 to 28 seconds calling sql batch but I'm not sure what is slow the applications or the sql server. I have the traces from the workstation and the server side. I'm seeing tcp keep alives but I'm not sure that is the problem https://www.dropbox.com/s/3nrh7fx67ny0xd2/sqlserver.pcap_anon.pcapng?dl=0 https://www.dropbox.com/s/o4jhy6xd27ti3ks/workstationtest.pcap_anon.pcapng?dl=0 asked 28 Jun '16, 18:49  patrickwill |
This is a static archive of our old Q&A Site.
Please post any new questions and answers at ask.wireshark.org.
do you have jumbo frames enabled on any of the network equipment?
FWIW There were some more details in the other (now closed) question on this topic: https://ask.wireshark.org/questions/53731/why-sql-batch-is-slow