How to get average rtt out of tcp conversation or import rtt values to the excel?

answered 2018-06-15 05:00:49 +0000

NJL
120 ●2 ●24 ●8

updated 2018-06-21 17:46:11 +0000

grahamb

flag of United Kingdom of Great Britain and Northern Ireland

23850 ●4 ●988 ●227 https://www.wireshark.org

Hi,

You can use the IO graph with the "tcp.analysis.ack_rtt" display filter in the "Y field", select "AVG(Y Field)" in the "Y Axis" drop-down and choose display filter (to focus on the TCP session of interest), interval, Style etc. as you see fit. If you want to export it to Excel, you can click save As, and select it as .csv and the import it into Excel.

The same can be done using command line, with tshark:

tshark -Y "display-filter to focus on the TCP session of interest" -r <inputfile> -Tfields -e "tcp.analysis.ack_rtt"

This will print the ACK_RTT values and you can then export that to a file and again import it into Excel.

edit flag offensive delete link

Comments

Thanks for replies. As I understand, tcp.analysis.ackrtt takes only acknowledgement RTTs. But after filtering tcp.analysis.ackrtt a get number of results less than the number of acknowledgements I got.
Could we say that avg rtt among all ack packets is avg rtt of all packets in the conversation?

Alex275 ( 2018-06-22 01:57:50 +0000 )edit

Not entirely sure what you mean. Are you able to share the capture file?

NJL ( 2018-06-22 09:10:33 +0000 )edit

Sorry, probably my misunderstanding. The number of ACK is ok. But my server has sent 65084 packets and received 427 571 packets back.

https://drive.google.com/open?id=1xwe...

And the number of ACK RTT that I got after using tshark command as you send was ~11000. Average RTT there was equal 111ms. But from TCP Stream Graph it doesn't look like this correct rtt.

https://drive.google.com/open?id=1Rie...

Alex275 ( 2018-06-24 07:26:57 +0000 )edit

I would appreciate the full capture file if I am to help you analyze this as I much prefer it to screen captures. If the capture contains sensitive/confidential data, you can sanitize it with TraceWrangler.

NJL ( 2018-06-29 18:05:37 +0000 )edit

add a comment

How to get average rtt out of tcp conversation or import rtt values to the excel?

1 Answer

Comments

Your Answer

Question Tools

Stats

Related questions

How to get average rtt out of tcp conversation or import rtt values to the excel? edit

1 Answer

Comments

Your Answer

Question Tools

Stats

Related questions

How to get average rtt out of tcp conversation or import rtt values to the excel?