Our SQL 2005 server is being hammered by our ZCM servers. When there is a SQL cluster failure, the ZCM servers (5 of them) continually try and reconnect to the SQL server.
The SQL admin guy has asked if there is any kind of setting from the ZCM side for the servers to stop trying after a perioid of time or amout of attempts and retry later rather than
continously trying. We have ZCM 10.3 with SQL 2005 and will be moving to ZCM 11 SP2 and SQL2008, but I want to see if this can be resolved now.
Has anybody else experienced this and has a upgrade resolved the issue or any other options.