This is our old Q&A Site. Please post any new questions and answers at

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

studentofsecurity's gravatar image

accept rate: 0%


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

Best regards...Paul

permanent link

answered 17 Oct '14, 13:29

PaulOfford's gravatar image

accept rate: 11%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 14 Oct '14, 04:35

question was seen: 2,250 times

last updated: 17 Oct '14, 13:29

p​o​w​e​r​e​d by O​S​Q​A