Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Insufficient Buffer Space issues Expand / Collapse
Author
Message
Posted Friday, May 01, 2009 8:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 27, 2010 7:54 AM
Points: 2, Visits: 7
We 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.



ErrorDescription="Error description not available" ErrorRelatedMoreInfo="">


"com.inet.tds.at" ErrorDescription="" ErrorRelatedMoreInfo="[TDS Driver]java.net.SocketException: recv failed: Insufficient buffer space">
com.inet.tds.at: [TDS Driver]java.net.SocketException: recv failed: Insufficient buffer space
at com.inet.tds.aq.a(Lcom.inet.tds.k;Ljava.lang.Throwable;)Ljava.sql.SQLException;(Unknown Source) at com.inet.tds.TdsDriver.connect(Ljava.lang.String;Ljava.util.Properties;)Ljava.sql.Connection;(Unknown Source)
at java.sql.DriverManager.getConnection(Ljava.lang.String;Ljava.util.Properties;Ljava.lang.ClassLoader;)Ljava.sql.Connection;(Unknown Source)


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 link

http://support.microsoft.com/default.aspx?scid=kb;EN-US;196271

i.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...

thanks
sandeep
Post #708485
Posted Tuesday, May 12, 2009 8:13 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, March 13, 2014 9:27 PM
Points: 3,283, Visits: 6,670
I 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 problem

-Roy
Post #715110
Posted Tuesday, May 12, 2009 1:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 27, 2010 7:54 AM
Points: 2, Visits: 7
we do not have stored procedures on this database.
Post #715410
Posted Tuesday, May 19, 2009 1:38 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 17, 2014 8:01 AM
Points: 1,682, Visits: 446
Try this

DBCC freeproccache
Dbcc dropcleanbuffers



- Pradyothana


http://www.msqlserver.com
Post #720129
Posted Wednesday, May 27, 2009 8:19 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, March 13, 2014 9:27 PM
Points: 3,283, Visits: 6,670
Pradyothana Shastry (5/19/2009)
Try this

DBCC freeproccache
Dbcc dropcleanbuffers

By doing this, you know that you are clearing all the caches execution plans... Right? That will have a performance impact...


-Roy
Post #724148
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse