Azure SQL Database Architecture

There are four layers in Azure SQL Architecture most quite similar to on-premises

  • Client Layer
  • Service Layer
  • Platform Layer
  • Infrastructure Layer
  • Client Layer: Is the interface for applications to access a SQL database the client layer includes SQL Server tools, (ODBC), ADO.NET, (PHP) and Tabular Data Stream (TDS) is used to transfer data between a SQL database and applications. SQL Server also uses TDS to communicate with applications. This allows applications such as .NET, ODBC, ADO.NET, and Java to easily connect to Azure SQL Database without any additional requirements
  • Service Layer: acts as a gateway between the client and platform layers
  • Platform Layer: (SQL Server, Azure Fabric, Management Services) Azure Services Fabric is Responsible for Load Balancing , Automatic Failover and Automatic replication of the SQL Databases between Physical Servers https://docs.microsoft.com/en-us/azure/service-fabric/service-fabric-overview and Management Services takes care of an individual server’s health monitoring and patch updates.
  • Infrastructure Layer: Layer responsible for administrating the OS and physical hardware


Ayman El-Nory

DB Consultant | SQL Server | MongoDB | Power BI | Azure | AWS | MCSA | MCSE | MCT | MCP | ITIL | Technical Author.
Azure SQL Database Architecture

Leave a Reply

Your email address will not be published. Required fields are marked *