You are here: Re: SQL server process architecture « MsSQL Server « IT news, forums, messages
Re: SQL server process architecture

Posted by Erland Sommarskog on 09/30/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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация