I'm noticing slow performance between a SQL server and a Windows client, with the occasional crash of the application on the client side. I have a capture from the SQL server and from the client side. So far I have noticed some high delta times, but not sure where to look next for the root cause. There is an app server that sits between the SQL server and the client as this is how the application is being used. The high delta times also show up between the app server and the SQL server as well as the app server to the client. Any thoughts on where to look next, other than the event logs? asked 14 Oct '14, 04:35  studentofsec... |
One Answer:
Hi, The best way to investigate this is to identify an instance of the slow response time in the client trace and then analyze the other trace data tier-by-tier. You can find a complete guide to help you do this at http://www.tribelabzero.com/resources Best regards...Paul answered 17 Oct '14, 13:29  PaulOfford |
