qiyuef (10/24/2013)
There should be a logic in the job to check if the fail over happened. otherwise , it will keep reset the MAXMemory setting to the same value.
The code to set the MaxMem will only run when the SQL Server Agent is started. Usually that doesn't happen too often.