We have an issue with AlwaysOn where it fails over to another node causing the job to fail . And this happens only one time a day at the same time. The job just runs some queries to aggregate some data and no other processes seems to running during that time.
I see the following errors during that time
AppDomain 10735 (SSISDB.dbo[runtime].10734) is marked for unload due to memory pressure.
I've increased the sessiontimeout to 180 secs, and that doesn't help.
How do I avoid failover even though there is a memory pressure?
Thanks