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