Networking Forums

Networking Forums > Computer Networking > Windows Networking > TIME_WAIT in NetStat

Reply
Thread Tools Display Modes

TIME_WAIT in NetStat

 
 
Jesse
Guest
Posts: n/a

 
      04-08-2005, 12:18 PM
If I understand correctly, the TIME_WAIT Status when you do a NETSTAT on the
server indicates that the connection has been closed, and it is waiting to
clear. Is that right? If so, we have a lot of SQL Server connections that
are in TIME_WAIT status mode. We may have well over 100 or so of these, and
they do not clear out very fast. My understanding (and what I've seen from
the settings) is that this is because of connection pooling. It will keep
the connection there for 120 seconds, just in case it needs to be used
somewhere else, but these connections are staying open way beyond 120
seconds. Why would they stick around like that, and how do I get them to
clear out sooner? Could they potentially be causing problems by not
clearing out?

I don't know if this is a SQL Server issue, or a networking issue. I've
tried the SQL Server forum, and haven't got any answers as of yet, but
figured I'd post here too to see if anyone had any suggestions.

Thanks,
Jesse


 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
TCP: FIN_WAIT1 to TIME_WAIT Radha Linux Networking 0 08-01-2008 07:06 AM
ipp TIME_WAIT DM Linux Networking 0 01-18-2006 07:51 PM
Simple TIME_WAIT question iksrazal@terra.com.br Linux Networking 2 06-28-2005 05:57 PM
kernel 2.4.21 and TIME_WAIT Maurizio Lo Bosco Linux Networking 3 03-26-2005 10:57 AM
Parameter to change TIME_WAIT interval Syam Linux Networking 2 02-17-2004 09:29 AM



1 2 3 4 5 6 7 8 9 10 11