Arun Sirpal looks at some Azure-specific DMVs, followed by the wait stats DMV:
Sys.geo_replication_links
This query will return primary and secondary databases in a geo-replication partnership. Here you will get the status of replication which could be in 1 of 3 states – pending, seeding or catch-up. You should run this under the master database.
Read on for the rest.