Understanding the error “An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was…
This error message, which is associated with the Winsock error WSAENOBUFS and actually comes from Windows rather than SQL Server directly, has two well-understood root causes. However, it still stumps people today, probably because there is no single source which explains both root causes and offers solutions for both. Here is a description of the two common situations where you may see this error and quick solutions for each: OS runs out of memory for TCP buffers When a powerful client machine, especially one with lots of RAM, is running an x86 version of Windows, people use the /PAE switch in the c:boot.ini file to allow applications on that machine to be able to address the full range of memory.
See the original post:
Understanding the error “An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was…
