Lesson Learned #8: Monitoring the geo-replicated databases.

We received multiple requests in order to have answered the following questions:

  • Is there needed a maintenance plan for geo-replicated databases?
  • How to monitor the geo-replicated databases

Answering the question: "Is it needed a maintenance plan for geo-replicated databases?",

No, there is not needed because is you have a maintenance plan for rebuilding indexes and update statistics for the primary database, these command will be executed in all geo-replicated databases that you have.

Answering the question: "How to monitor the geo-replicated databases".

We developed a PowerShell Script, as an example, for monitoring any geo-replicated database(s) and server(s) in Azure SQL Database. Every time that you executed this PowerShell command you will have a JSON file in the following format for every server, database, query for user database (or query master database) and YYYYMMDDHHNNSS. Please, feel free to update and improve it.

Skip to main content