The Azure SQL Internals Layer

Using the tests mapped to this layer, you can determine:

• whether/not geo-replication is enabled;
• whether/not the target database instance is a primary database instance;
• the mode of the secondary database;
• the replication status of the database;
• how effectively the Microsoft SQL Azure database server utilizes the sessions and process resources it is configured with;
• the number, nature, and duration of waits etc.

Figure 1 : The tests associated with the Azure SQL Internals layer