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 Components

I will end this chapter by talking in broad terms about the various SQL Server components involved in processing the typical client request. Several of these are discussed in more detail in other chapters; we'll just hit the high points here. A typical client request is one that queries the server for data that resides in a database. Understanding how these components interoperate and the workflow between them will give you some good insight into how the server works internally.

As I've mentioned, client requests come into the server via SQL Server's Net-Libraries. These requests are then scheduled for processing via UMS. The language processing and execution (LPE) component within the server then takes each request 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