SQL Server Architecture

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.

sql_server_architecture

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s