Insufficient Buffer Space issues

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » In The Enterprise » Insufficient Buffer Space issues

Insufficient Buffer Space issues

Rate Topic

Display Mode

Topic Options

Author

Message

sandy.chaudhary

Posted Friday, May 01, 2009 8:31 AM

Forum 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

Roy Ernest

Posted Tuesday, May 12, 2009 8:13 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 11:29 AM
Points: 3,280, Visits: 6,626

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

sandy.chaudhary

Posted Tuesday, May 12, 2009 1:17 PM

Forum 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

Pradyothana Shastry

Posted Tuesday, May 19, 2009 1:38 PM

SSCommitted

Group: General Forum Members
Last Login: Monday, March 25, 2013 5:30 AM
Points: 1,641, Visits: 423

Try this

DBCC freeproccache
Dbcc dropcleanbuffers

- Pradyothana

http://www.msqlserver.com

Post #720129

Roy Ernest

Posted Wednesday, May 27, 2009 8:19 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 11:29 AM
Points: 3,280, Visits: 6,626

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 »

Permissions