Automating mirroring monitoring RRS feed

  • Question

  • Just a bit confused by the variety of options in monitoring a "full-safety" mirroring setup.

    I want an email (or event log) alert when either the state changes or performance is laggy. Various blogs etc suggest setting up via the Database Mirroring monitor GUI (set thresholds) and/or using the automated job/procs that come with mirroring. The option then seems to be to either write a fairly lengthy process to poll the relevant system tables or setup database alerts to generate the email etc.

    There doesnt seem much consensus on the best approach. I don't want lengthy, bespoke scripts - there must be "out of the box" monitoring to configure?

    Any direction/best practice appreciated.

    Version is SQL 2012

    Tuesday, March 22, 2016 2:55 PM


All replies