No buffer space
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
June 2nd, 2010 6:41pm

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
Free Windows Admin Tool Kit Click here and download it now
June 3rd, 2010 8:22am

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
June 3rd, 2010 7:54pm

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
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2010 7:07pm

Hi, Any updates on this? Also, just recalled that you can always use procmon from for situations like this. Its available at, Amit Saxena
June 15th, 2010 5:03am

Ny update on this Bharat?Regards, Amit Saxena
Free Windows Admin Tool Kit Click here and download it now
June 19th, 2010 7:28pm

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: Thank you bharat
September 20th, 2010 9:31am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics