concurrent TCP connections

[babar.munir]

today one of my SQL reporting server stop responding its services. after some troubleshooting and ran the NSLOOKUP, i found there were 100s of TCP connections were in Time-Wait state. i tried to kill forcefully these connections, but unable to do so, so at the end i had to restart my server.

wht i want to know can i get an alert if such kind of connections occur again or exceed some limits..
for example if 100 http connections are going to establish with server, can i get alert when it reaches to 20th connection..

HM version: 9.58
SQL server = 2008

[KS-Soft]

Yes, you may see a lot of sockets in TIME_WAIT state.
Microsoft says

NOTE: It is normal to have a socket in the TIME_WAIT state for a long period of time. The time is specified in RFC793 as twice the Maximum Segment Lifetime (MSL). MSL is specified to be 2 minutes. So, a socket could be in a TIME_WAIT state for as long as 4 minutes. Some systems implement different values (less than 2 minutes) for the MSL.

To improve the ability of the Windows operating system to deal with a high rate of network connections you may add the following registry entries in
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\TCPIP\Parameters
TcpTimedWaitDelay - DWORD value, in the range 30-300, that determines the time in seconds that elapses before TCP can release a closed connection and reuse its resources. Set this to a low value to reduce the amount of time that sockets stay in TIME_WAIT.

wht i want to know can i get an alert if such kind of connections occur again or exceed some limits..
for example if 100 http connections are going to establish with server, can i get alert when it reaches to 20th connection..

You may check total number of sockets in TIME_WAIT state using SNMP Table test method
http://ks-soft.net/hostmon.eng/mframe.h ... #snmptable
- OID 1.3.6.1.2.1.6.13.1.1
- Apply filter: skip items <> from 11
- Alert then row count is > than 100

Regards
Alex