Press "Enter" to skip to content

DMVs For Azure SQL Database

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.