Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Insufficient Buffer Space issues


Insufficient Buffer Space issues

Author
Message
sandy.chaudhary
sandy.chaudhary
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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.ThrowableWinkLjava.sql.SQLException;(Unknown Source) at com.inet.tds.TdsDriver.connect(Ljava.lang.String;Ljava.util.PropertiesWinkLjava.sql.Connection;(Unknown Source)
at java.sql.DriverManager.getConnection(Ljava.lang.String;Ljava.util.Properties;Ljava.lang.ClassLoaderWinkLjava.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
Roy Ernest
Roy Ernest
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2742 Visits: 6860
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
sandy.chaudhary
sandy.chaudhary
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 7
we do not have stored procedures on this database.
Pradyothana Shastry
Pradyothana Shastry
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1732 Visits: 486
Try this

DBCC freeproccache
Dbcc dropcleanbuffers


- Pradyothana


http://www.msqlserver.com
Roy Ernest
Roy Ernest
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2742 Visits: 6860
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search