May 1, 2020

SQL Server Architecture


We can put SQL Server architecture in 3 main categories...

    1. Protocol Layer
    2. Storage Layer
    3. OS Layer 




1. Protocol Layer
      Connection Protocol
      Query Processing



2. Storage Layer
     Lock Manager
     Transaction Manager
     File Manager

     Buffer Manager 

3. OS Layer
    Scheduler Manager
    Memory Manager
    Resource Manager
    Lazy Writer
    Deadlock
    IO Manager.

No comments:

Post a Comment

If you have any doubt or question, please contact us.