Always On Secondary falling behind

  • Hi Experts,

    How can setup email if the RO gets behind more than 10 minutes?

    https://technet.microsoft.com/en-us/library/dn135338%28v=sql.110%29.aspx

    From the above link think i should chose the RTO part but how about triggering a mail?

  • what is RO?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • There are DMVs that expose Always On metadata and status information. If you aren't familiar with them and can't find a blog post just set up Profiler and open the SSMS monitoring GUI. Great way to see what the GUIs do!

    As for email, Database Mail allows you to send mail using TSQL. Set up a SQL Agent job to run every so often and email if AG is too far behind. May be able to do an Alert for this too, come to think of it.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • Perry Whittle (3/4/2015)


    what is RO?

    Sorry for the confusion.. I mean Read Only Database.

Viewing 4 posts - 1 through 3 (of 3 total)

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