I did a change auditor upgrade from 6.5 to 6.9.5.
Since the new version support SQL 2016, I got a new DB created as well. While upgrade it initially had issues with getting the uninstall of existing version but that was sorted out.
But now, there are bigger problems. After upgrade, the CA co-ordinater service hangs every 5 to 10 mins and throws error. I have to kill the process and then it takes ages for the service to restart.
I checked the logs and DB connection to the new Database is absolutely fine and no issues around it.
.Net also got upgraded during the install so that is not an issue either. Any help would be appreciated. The support has not been too good on this from quest tech support and not getting apt amount of help from them. Too late to respond, not escalated internally yet, etc.