SQL Server architecture is very important and it is very deep subject. Mainly three phases are
i) Relational Engine.
ii) Storage Engine
iii) SQL OS
I am telling simply how a query is executed internally and how many components are involved in every phase to generate the query output.
To get more details about SQL Server architecture download the below link.