Ask Your Question
0

Barcode scanner, MSSQL, retransmission...cause ?

asked 2018-09-24 09:55:57 +0000

vmiro gravatar image

updated 2018-09-24 10:02:25 +0000

HI, I'm experiencing intermittent slowdowns using barcode scanners in a warehouse. Here is the captured packets and the flow. One image is the flow without retransmission and the other is with. Barcode scanners are connected to WiFi and in the same subnet as SQL server. WiFi controller shows no dropped packets from client. It looks like SQL expects request from the client but when it doesn't receives it and then he sends retransmission TCP packet.

image description

Any suggestion about what could cause this behaviour, would be appreciated, thanks ;)

edit retag flag offensive close merge delete

Comments

This is an interesting question, but we need more data I think. PCAPs would be more useful. You can anonymize them using TraceWrangler.

Is this pattern consistent? How often does this happen? Is it the same packet getting dropped (retransmitted) every time? Where capture point is? Directly on WiFi controller or before it?

Transation completion time difference between two samples is 0.5 sec, do you mean this slowdown? I suspect I wouldn't notice it :) But if you do thousands of scans.. maybe.

Packet_vlad gravatar imagePacket_vlad ( 2018-09-25 13:51:33 +0000 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-09-26 10:22:38 +0000

Christian_R gravatar image

updated 2018-09-26 10:27:19 +0000

Seems you are tracing on or next to the server. So I think/guess (due to screenshot) the Response after the RPC call got lost. And a RTO is triggered. More can´t be said without having a trace. But it seems you have packet loss somewhere or some problems in your WIFI setup.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2018-09-24 09:55:57 +0000

Seen: 577 times

Last updated: Sep 26 '18