InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 08:41:11 GMT20http://www.sqlservercentral.com/Forums/Topic708485-54-1.aspx[quote][b]Pradyothana Shastry (5/19/2009)[/b][hr]Try thisDBCC freeproccacheDbcc dropcleanbuffers[/quote]By doing this, you know that you are clearing all the caches execution plans... Right? That will have a performance impact...Wed, 27 May 2009 08:19:20 GMTRoy Ernesthttp://www.sqlservercentral.com/Forums/Topic708485-54-1.aspxTry thisDBCC freeproccacheDbcc dropcleanbuffersTue, 19 May 2009 13:38:37 GMTPradyothana Shastryhttp://www.sqlservercentral.com/Forums/Topic708485-54-1.aspxwe do not have stored procedures on this database.Tue, 12 May 2009 13:17:44 GMTsandy.chaudharyhttp://www.sqlservercentral.com/Forums/Topic708485-54-1.aspxI have a feeling that quite a bit of your Stored Procs are compiled with out the "SET NOCOUNT ON" . This can eat up your Buffer Space. Restart will fix it but it will come back again if you have the above mentioned problemTue, 12 May 2009 08:13:30 GMTRoy Ernesthttp://www.sqlservercentral.com/Forums/Topic708485-54-1.aspxWe have a sql server 2000 SP4 install on Windows 2003. There are about 20 databases in this instance and at peak we see about 130 connections from various ERP/Analytics applications.SQl server is installed on box 1 and there are 3 other server boxes from where connections originate to the sql server databases.Of late on the application we have been seeing the following error. Some of the application uses a database driver from INET.<?xml version="1.0" encoding="UTF-8"?><Errors><Error ErrorCode="com.inet.tds.at"ErrorDescription="Error description not available" ErrorRelatedMoreInfo=""><Attribute Name="ErrorCode" Value="com.inet.tds.at"/><Attribute Name="ErrorDescription" Value="Error description not available"/><Error ErrorCode=[b][/b]"[b]com.inet.tds.at" ErrorDescription="" ErrorRelatedMoreInfo="[TDS Driver]java.net.SocketException: recv failed: Insufficient buffer space"><Stack>com.inet.tds.at: [TDS Driver]java.net.SocketException: recv failed: Insufficient buffer space&#xd;at com.inet.tds.aq.a(Lcom.inet.tds.k;Ljava.lang.Throwable;)Ljava.sql.SQLException;(Unknown Source)&#xd; at com.inet.tds.TdsDriver.connect(Ljava.lang.String;Ljava.util.Properties;)Ljava.sql.Connection;(Unknown Source)&#xd;[/b]at java.sql.DriverManager.getConnection(Ljava.lang.String;Ljava.util.Properties;Ljava.lang.ClassLoader;)Ljava.sql.Connection;(Unknown Source)&#xd;We have monitored the incoming connections to the database and found that beyond 120 connections the application throw the above error.also, netstat results show about 4000 packets coming to the database server box.At this point, we made changes as per the following linkhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;196271i.e MaxUserPort was made to max.i verified that the number of connections to sql server instance is 32667..However, with the above changes and the verification, the error still continues...Looking forward for the gurus to respond...thankssandeepFri, 01 May 2009 08:31:07 GMTsandy.chaudhary