Wednesday, November 28, 2012

Components of SQL Server Engine

Four major components:

Protocol layer: interprete betwwen client and relational engine
Relational engine/Query Processor: parse,compile,optimize query.
Storage engine: access data
SQLOS: thread management, deadlock detention, buffer management



No comments: