Member-only story
SQL Server Architecture
Not a medium member? Read here!
I always recommend looking at the lowest level of how things works, this level is usually the architecture.
If you master the SQL Server architecture, the understand of a DML, DDL, Locks and Blocking will be much easier to understand.
It looks complex, but every piece is there for a reason.
Architecture
The SQL Server architecture consists of three main components:
- Protocol Layer
- Relational Engine
- Storage Engine
Architecture diagram:
Protocol Layer
The protocol layer is responsible for managing communication between clients and the SQL Server.
It handles client authentication, establishing connections, and session management. Additionally, it translates SQL commands sent by clients into instructions understandable by the SQL Server engine.
The MS SQL server supports three types of client-server protocols:
- Shared Memory: In this protocol, both the client and…
