March 4, 2015 at 8:46 am
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?
March 4, 2015 at 9:27 am
what is RO?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2015 at 10:13 am
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
March 5, 2015 at 2:08 am
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