Exploring the Components of SQL Server: Network Interface Layer, Database Engine, Storage Engine, and SQLOS

Architeture 1 Minute
  1. The Network Interface Layer: This component handles the unwrapping of the TDS packet received from the client’s end.
  2. The Database Engine: Responsible for executing database queries, the query processor processes and executes the queries.
  3. Storage Engine: This component stores the database using a set of OS system files, including objects, indexes, and tables. Each file has a logical name used in T-SQL statements and a physical name seen in the OS file structure. The storage engine can be further divided into Pages and Extents, which will be discussed later.
  4. SQLOS: The SQLOS layer manages operating system resources, including memory/buffer management, exception handling, extended events, resource governance, and I/O operations.

SQL_archi

Unknown's avatar

Published by Abhishek Dwivedi

Hello there, I'm Abhishek Dwivedi, a certified MSSQL/Azure professional affiliated with Microsoft. Currently, I serve as a Database Subject Matter Expert for an Asset Management firm based in Singapore. My journey with SQL Server began with version 7.0, and since then, I have worked extensively with all subsequent versions. While my expertise primarily lies in MSSQL, I also possess fundamental knowledge of Oracle database administration. However, my latest fascination revolves around cloud-based technologies. To stay abreast of the latest developments in SQL Server and related technologies, I avidly consume a wide range of resources, including books, articles, blogs, white papers, case studies, and user forums. The vast wealth of knowledge available never fails to amaze me. It is an honor for me to contribute to the SQL Server Community through my blog, where I share insights and experiences on various database-related topics that I encounter in my day-to-day work. Feel free to connect with me on LinkedIn via my profile at www.linkedin.com/in/abhishek-dwivedi-178b1050. I look forward to engaging with fellow professionals and enthusiasts in the field. Best regards, Abhishek Dwivedi

Published

Leave a comment