Setting Threshold values for warnings in database mirroring

by BeginnerDBA   Last Updated July 26, 2017 14:06 PM

I am trying to set up the threshold warnings for PARAMETERS below:

Unsent log; Unrestored log;Oldest unsent transaction ; Mirror commit overhead

I have gone through the link here to understand what these are how they work.

But i would need some practical answers on these as per your experience for different environments.

How we measure the appropriate threshold values? Do we need to run counters or some queries to determine or these values are something i need to get from Business owners as per RTO or RPO?

Thanks



Related Questions





Database Mirroring error, but everything looks OK

Updated March 28, 2017 14:06 PM

Mirrored TDE DB Performance

Updated August 10, 2018 20:06 PM