Explaining SQL Server internals
Your SQL Server workload and environment may not run with the performance you expect or require, and you'll need to troubleshoot SQL Server. For a good troubleshooting approach, you need to have a basic understanding of the SQL Server architecture and internals since SQL Server is a very complex software. There are four main components of the SQL Server architecture:
- SQLOS
- Storage engine
- Query processor
- Protocol layer
In the following image, you can see all these components and their relationship:
Fig. 6.1 – SQL Server architecture components and relationships
We'll look at the protocols first.
