Performance issue with SQL based application, suspect client side connectivity.
We have a network with about 100 or so clients and maybe 15 servers, alot of which host applications. For some reason, only one application seems to be having latency when running certain functions within the application. We have torn the entire SQL server and network apart looking for issues and everything looks to be performing flawlessly. In addition, other applications within the same network run at lightning speed, some of which transfer much much larger files.
Please see the attached capture from the client side as I am not a wireshark expert and I think this analysis goes beyond our capabilities at this point. I do however, believe there is a client side network or connectivity issue taking place.
Can you please capture the 3 way handshake of the session, too.
You got it, I will capture both ends and post it today.