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 SQL Azure Server layer