O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required