Looking for SQL Server 2019 Architecture Diagram

LCerni 1 Reputation point
2021-02-19T01:43:00.273+00:00

I am looking for an Architecture Diagram for SQL Server 2019. Can someone point me to a web site? I cannot find anything current.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,865 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,640 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 44,816 Reputation points
    2021-02-19T06:52:09.763+00:00

    SQL Server is a very complex system with a wide architecture, so what are you looking for in detail?

    A first start is SQL Server technical documentation

    0 comments No comments

  2. LCerni 1 Reputation point
    2021-02-19T20:14:46.32+00:00

    I had found this but I am thinking it is old and I was hoping for something updated.

    70172-sql-server-1.jpg70168-sql-server-2.jpg


  3. CarrinWu-MSFT 6,871 Reputation points
    2021-02-22T05:51:00.25+00:00

    Hi @LCerni ,

    We probably won't change the internals of SQL Server, the diagrams which you found are still accurate.
    Here are some references for you to learn SQL server further:
    SQL Server Books Online
    Introduction to SQL Server Internals and Architecture
    SQL Server Architecture Explained: Named Pipes, Optimizer, Buffer Manager
    SQL Server Architecture Overview

    Best regards,
    Carrin


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.