hi all,
I am not sure if this is the right forum..
we have bunch of app servers deployed on windows 2008 R2 machine connecting to SQL server running on another machine.
once a week, we start getting this error.
java.sql.SQLException: Network error IOException: No buffer space available (maximum connections reached?): connect
I was able to reproduce the error on my local windows 7 machine. this error is throw when the OS runs out of dynamic ephemeral ports.
So we went ahead and increased the port range on our server until we figured out a way to troubleshoot the issue. but its not helping and every week to 10 days, we start getting the error.
From the various testing, it looks like there could be process that is basically running wild and using up the ephemeral ports. by the time we log on and capture the netstat the number of ports are in hardly 1000's.
is there any tool similar to port reporter (compatible with windows 2003) on windows 2008? i tried the winsock event log but couldn't make much head way.
i am open to any ideas on solving this issue..
thanks
bharat

There is an amazing pack of free network admin tools. click here to download it

Hi,
Thank you for your post here.
What about the Sysinternal tool TCPView? It will show detailed listings of all TCP and UDP endpoints and the name
of the process that owns the endpoint.
TCPView for Windows v2.54

http://technet.microsoft.com/en-us/sysinternals/bb897437.aspx


There is an amazing pack of free network admin tools. click here to download it

thanks miles.. from my understanding,
the port reporter will be running as service and logs the port information any time its opened
where as tcp view is a console app .
Th issue surfaces randomly either once a week or once a month and hence will be helpful if its a tool that can be run unattended.

thanks
bharat

Need to support users over the internet? click here try our remote control online beta

When the sockets are all consumed, you shall receive an event 14198 or 2019. When it happens, you can use the option "attach a task to this event" and then, attach it to a batch file to pipe the current netstat-anob. Try to run a few loops of netstat to a
few different file names (to avoid over-writing). This is the fastest action I can think of.
Also, take an approach of process of elimination. Check the event log before the event comes, see what was happening to the machine, whcih app was doing what. Try MSCONFIG some non-ms process in bunch of five.
I hope you have already given MaxUserport as 65535.Regards, Amit Saxena

Need to support users over the internet? click here try our remote control online beta

Hi,
Any updates on this? Also, just recalled that you can always use procmon from

www.sysinternals.com
for situations like this. Its available at

http://technet.microsoft.com/en-in/sysinternals/bb896645.aspxRegards
, Amit Saxena

There is an amazing pack of free network admin tools. click here to download it

Ny update on this Bharat?Regards, Amit Saxena

Need to support users over the internet? click here try our remote control online beta

hi amit,
I think we have figured out the issue. we turned off the http and outlook scanning module on the anti virus that was installed on the server and after that we haven't seen out of buffer space issue on that server.
The issue used to crop up once a month and we used to reboot the system. And it has been more then 2 months since the last out of buffer space issue on that server.
links that helped us in pointing to anit-virus:


https://trac.torproject.org/projects/tor/wiki/TheOnionRouter/WindowsBufferProblems


https://trac.torproject.org/projects/tor/ticket/98


Thank you
bharat

There is an amazing pack of free network admin tools. click here to download it