Always On Latency Monitoring Alert

Hello Buddy DBAs,
In this video I am showing a script that I created to continuously monitor an Always On Availability Group for any synchronization delay due to latency or due to some database not performing data movement.
Please feel free to test this script in your Test Environment and promote it to Production if you like. Please visit this space again for updated version of script in future.
If you face any error or issues please let me know in comments.
Script
***************************************************************************
Please find 'AlwaysOnMonitoring.sql' file from the below
google drive folder -
drive.google.c...

[@amanuelambaye3344]

Interesting and very helpful. Let's here about how you transfer the jobs in running on the primary replica as you mentioned at the end of the video.

[@narayananaidu9761]

so helpful.. i wish that you do more videos like this

[@gaganviharreddy798]

Explained crystal clearly. Thanks for your time brother -:)

[@voter2053]

Please do more vedios...excellent explanation

[@mayankprajapati6962]

Very good explanation bro.

[@rajaster]

would love to hear your way of failing over jobs, i had a way in another company where i have a jobsync table that was used to ensure jobs were failed over and a master job to enable/disable them

[@Shanmugamanickavel]

Hi Sir Can you please share me the video on Always on after failover job should continue to run in secondary[new primary]...im very much impressed on your videos