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


I've got a slightly duplicate of this post on, but I'm hoping some of you guys have some valuable input on this problem.

Thing is, my box with Win8 apparently sends an extra ACK package when I run SQL queries, and it seems like that package is creating a ~500 ms delay. Here's a short snippet of logs from my box and a Win 7 Box. (mine has multiboot and doesn't have the problem when booted with Win7)

Other box:

"20","0.286775000","","","TDS","116","SQL batch"
-- 22 is ack for 21, no delay
"22","0.312462000","","","TDS","116","SQL batch"

My box:

"19","2.949616000","","","TDS","116","SQL batch"
"21","2.974793000","","","TCP","54","50457 > sslp [ACK] Seq=775 Ack=1955 Win=65792 Len=0"
-- 21 is ack for 20
-- 22 is not ack for 20, although ack bit is set
-- 500 ms delay before each new SQL batch 
"22","3.494747000","","","TDS","116","SQL batch"
"24","3.520363000","","","TCP","54","50457 > sslp [ACK] Seq=837 Ack=2381 Win=65280 Len=0"

Hope someone has seen this before and know exactly what setting I can change or command I can run. ;)

[edit] Reason ACK packet is on SSLP instead of MS-SQL-S is that SQL Server in question runs on port 1750 instead of 1433. Same behavior on other servers though, so never mind it.


asked 22 Aug '13, 04:29

Lars-Erik's gravatar image

accept rate: 100%

edited 22 Aug '13, 05:18

Purp identified.

It was Trend Micro Worry Free (!) Business Security.

Upgraded it, and problem gone.


permanent link

answered 28 Aug '13, 02:52

Lars-Erik's gravatar image

accept rate: 100%

Hm, the packet that is sent out is just 62 bytes in length. So this may be the Nagle algorithm that is slowing you down here. This blog suggests to turn it off

"To disable TCP packet batching, we set TcpNoDelay to 1, so all packets will be send no matter what size they have (normally TCP sends out batched packages)."

permanent link

answered 22 Aug '13, 04:58

mrEEde's gravatar image

accept rate: 20%

Thanks, I've tried setting both TcpNoDelay and TcpAckFrequency to 1 and AckFreq to 2, neither has any effect what-so-ever.

Although I'm not entirely sure I put it in the right key. I used HKLM\SYSTEM\ControlSet001\Microsoft\Services\tcpip\Parameters\Interfaces\[the one that has my ip in a setting].

I'll try nodelay once more with a restart just to be sure I've tried properly.

[edit] Tried TcpNoDelay = 1 on all adapters for good measure, restart, no effect. :(


(22 Aug '13, 05:06) Lars-Erik
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: 22 Aug '13, 04:29

question was seen: 2,841 times

last updated: 28 Aug '13, 02:52

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