I've got a slightly duplicate of this post on http://social.technet.microsoft.com/Forums/windows/en-US/558553e7-d602-4584-a5dc-97f813890edc/extra-ack-packet-delaying-each-query-with-500-ms-on-windows-8, 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)
Hope someone has seen this before and know exactly what setting I can change or command I can run. ;)
 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
edited 22 Aug '13, 05:18
It was Trend Micro Worry Free (!) Business Security.
Upgraded it, and problem gone.
answered 28 Aug '13, 02:52
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)."
answered 22 Aug '13, 04:58