Posted by Erland Sommarskog on 10/01/38 11:19

John Jayaseelan (john.jayaseelan@caravan-club.co.uk) writes:
> Is 'sqlserver.exe' the only windows process does everything for that
> instance of the database?

Depends on what you mean with everything...

SQL Agent is a job scheduler. But it is really just another client. If
you have Analysis Services, Reporting Services etc, they are also separate.

But when it comes to running SQL queries, sqlserver.exe is the one
and only yes.

> Please explain in details the SQL server process architecture.

Books Online is a good way to start, there are some introductory
sections on architecture. See below for link.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]