Mirroring alerts

  • pols

    SSC Eights!

    Points: 861

    Hi,

    In one of our customers the database mirroring was already configured. After long years they came to us and asking to configure the database mirroring alerts. The alerts needs to come to their mailid if some things happens to the mirroring.

    In the server the database mail id is already configured for failure jobs.

    Now i need to configure same mailid for mirroring alerts also.

    I am completely lost in touch with mirroring after always on came into the market.

    Can anyone please help me to configure db mirroring alerts in the same server.

    what exactly i need to follow to set mail alerts for current mirroring setup.

    Thanks,

    Jo

    • This topic was modified 7 months, 2 weeks ago by  pols.
  • Site Owners

    SSC Guru

    Points: 80375

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • HandyD

    Mr or Mrs. 500

    Points: 507

    Depending the level of monitoring you want, you can setup some simple state monitoring for mirrors using the instructions here: https://www.mssqltips.com/sqlservertip/1859/monitoring-sql-server-database-mirroring-with-email-alerts/

    If you want more comprehensive monitoring of mirroring health and performance, check out the Microsoft Docs article here: https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/use-warning-thresholds-and-alerts-on-mirroring-performance-metrics-sql-server?view=sql-server-ver15

     

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply