I’m trying to use BMF to test tpcc user load while failing over SQL2008 from the principal to the mirror, using sql mirroring.
In Windows 2008 Server the OBDC configuration allows to specify a Fail over server, which i explicitly enter. When I test the OBDC object, it works no matter which is acting as the principal or mirror server.
When i initiate the failure during user load, i get a bunch of communication link failures in the agent.
I also tried to use the Native SQL driver, but that does not fail over the user load to the mirrored database.
Is there a way to have the BMF agent reconnect the users at the mirror db?