Latency and Line tracing between SQL server and Application

SQL Server Administration
1

Hi All,

I have an issue which probably comes out of a latency between an application and the SQL server.

Using a packet capturing or network sniffers not realy show teh actualk delay from a SQL perspective.

Do you familiar with a tools or a any other way to monitor a delay on the SQL that might be caused by an environment?

Thank you in advance,

Urmas

2

Not sure if that is going to help, but if you run the query in SSMS and enable client stats, it will show you the number of packets and roundtrips from the given execution. It also shows you the time it took.

It might not be as details as to when it leave the app and get a response, but at least you can get some idea.