SQL Azure Architecture

SQL Azure resides in Microsoft Data center provides relational database to application with four layer of abstraction.

Four layers of abstraction can be depicted as below,


Client Layer

This layer is closest to the application. SQL Azure connects with client application with Tabular Data Stream interface in exactly the same way SQL Server does.


Client layer can be ranging from a managed .NET application to PHP application. It could be a SilverLight web application or WCF Data Service. Client layers connect with other layers using Tabular Data Stream.


Client layer may be in client data center [On premise] or it may be in Data center of service provider [Cloud].

Service Layer


Service layer performs task of provisioning of database to the user cross ponding to Azure account. This mainly performs

a. Provisioning of Database to a Azure account

b. Billing of the usage

c. It performs the task of connection routing between client applications from the client layer to the actual physical SQL server in Platform layer.

Platform Layer

Physically SQL Server resides in this layer. There could be many instances of SQL server.


SQL Azure Fabric manages instance of SQL Server.

Task performed by SQL Azure Fabric

1. It enables automatic failover

2. It does load balancing

3. It does automatic replication between physical servers.


Each instance of SQL Server is individually managed by SQL Azure Fabric.

Management Services performs below tasks,

1. Monitoring health of individual servers.

2. Installing patch up

3. Upgrading services

4. Automated installations

Infrastructure Layer

In this layer IT level administration tasks being performed. Physical hardware and operating systems is being administered in this layer.


3 responses to “SQL Azure Architecture”

  1. hi.its nice.please provide me the deep about azure

  2. Nice writeup on SQL Azure. This will surely force me 🙂 to dive in the world of Azure. Thanks DK. Keep posting kind of articles. it helps a lot.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at WordPress.com