Occasional delay in processing incoming packets

From: James (needadohelp_at_hotmail.com)
Date: 08/18/04 

Date: 17 Aug 2004 18:38:33 -0700

I have a problem where occasionally (less that 1%) a packet is not
processed for as long as 25 seconds.

1) I get the exact same behavior with ADO 2.8 and ADO.NET.

2) A detailed view of the chain of events looks like this:

• T+0 seconds – connection from the pool is allocated
• T+0 seconds – vb call to Command.Execute (or c# call to
DataAdapter.Fill)
• T+0 seconds – single packet (118 bytes) is sent to database machine
(from a web server)
• T+0.1 seconds – ack received from database machine indicating packet
was successfully received in full
• T+25 seconds – SQL Profiler trace "Start Time" for database call
• T+25 seconds – SQL Profiler trace "End Time" for database call
• T+25 seconds – data returns to application
• T+25 seconds – connection is returned to the pool

So the "lost time" occurs on the database machine between the time the
packet is received, and the time Profiler claims SQL Server started
working on the query.

I've tried to run perfmon on the obvious counters on the database but
I've failed to find anything out of the ordinary. There are so many
counters! Any ideas on what specifically I should be looking at now?

 ~ James

Occasional delay in processing incoming packets

Relevant Pages

  • Re: Speed Mismatch?!?
    ... This _is_ a clue. ... all gi...I _WAS_ trying to buffer somthing somwhere, ... how but wondering if packet A overran packet B to the point that the ... interface counters care what goes on between the guts that contect ...
    (comp.dcom.sys.cisco)
  • Re: 64 bit packet counters
    ... > AH>use of 64 bit packet counters and the differentiation between ... > You may lookup the discussions in the mailing lists. ... > that I plan to implement in my snmp daemon) is to periodically monitor ... incremented per packet, and have a background task/thread to update the ...
    (freebsd-net)
  • Re: Strange issue with NDISPROT xmit and the network performance counter
    ... It seems that the packet counters in the NIC are different from the counters ... from the Task Manager counts only IP packets and completely ignores my ... custom Ethernet frames. ...
    (microsoft.public.development.device.drivers)
  • Re: MII preamble size
    ... size preamble or should it reject packets that don't have ... the exact size specified for the transmit case? ... PHY will be looking at tx_en from the MII to determine transmit packet start ...
    (comp.dcom.lans.ethernet)