Post reply

Unab An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full xxx.xx.xx

  • November 7, 2011 at 3:13 pm

    #245695

    I keep getting this error in my SQL Server Agent logs, and my jobs are failing. this is on a 32 gig/64 bit server with 2008 r2.

    I have Max set to 25 gig and Min set to 15 gig. Server is running SSRS and SSIS. Pretty much a BI server.

    From the Job log:

    Unable to connect to the remote server System.Net.Sockets.SocketException: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full 172.16.16.234

    From the Sql Server Agent error log

    Message

    [165] ODBC Error: 0, TCP Provider: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full. [SQLSTATE 08001]

    Any ideas?

    Thanks

  • November 7, 2011 at 3:41 pm

    #1404200

    Possibly memory pressure on the OS.

    check out total memory usage of SQL (+ SSIS + SSRS) via perfmon counters. check out out paging and available memory as well.

    Do you have the /3GB switch set in boot.ini? If so remove it.

    ---------------------------------------------------------------------

  • November 8, 2011 at 7:59 am

    #1404571

    running 64 bit 2008 windows so switch is not an issue.

Viewing 3 posts - 1 through 2 (of 2 total)

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