Insufficient Buffer Space issues

  • 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: [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) [/b]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

  • 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

  • we do not have stored procedures on this database.

  • Try this

    DBCC freeproccache

    Dbcc dropcleanbuffers

  • 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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply