Guru's Guide to SQL Server Architecture and Internals, The

SQL Server and Networking

You'll recall that in the Networking chapter I said that SQL Server uses standard networking API calls to accept and process connections. You're probably already aware that SQL Server calls into its network library code (which resides in separate DLLs) to accept and process user connections. What you may not be aware of is that these DLLs, in turn, call standard Windows networking API functions to carry out their work.

When listening for connections over TCP/IP, the Windows socket APIs that we discussed in the Networking chapter are used heavily. The SQL Server Net-Library code calls accept and WSAAccept to accept new connections and the various other socket and Win32 I/O API functions to process client requests and ...