We have Exchange 2016 and have for a while been relying on the DAG Activation Preference functionality mentioned here
Recently we noticed that the balancing mechanism isn't working, and we have some servers with many DBs, and others with none, where in a working world all servers would have at least one DB.
We tried to manually move one of the "misplaced" DBs to the host with the correct Activation Preference and it worked OK. Before we run the RedistributeActiveDatabases.ps1 script to manually balance the DBs, I wondered if there is a log (text file, event log, etc.) where we can view if the balancing is (or isn't) occurring, and why.
I checked all the commands and everything looks good:
