multisubnetfailover=true

Interesting suggestion.  I'm more inclined to have the secondary reject connections for now.  If I do as you suggest, I think queries will continue to succeed when they're connected to...

Is it fluctuating?  I can't really say how often this happens.  It seems as if the listener decides incorrectly which system to forward connections to and continues forwarding incorrectly for...

Seems as though this poster (SQL listener connection fluctuates between primary and Secondary. (microsoft.com)) had a similar problem but there wasn't a solution.

Thanks for the suggestion. The trace activity is coming from Red Gate Software - SQL Tools. If I ask my coworkers to close SSMS (because we use several...

It's really a matter of preventing someone from accidentally using the connection string for the production database. A dba or sysadmin should have sole access to the login credentials...

Oh thanks Lowell and S.Buddy. Those are great suggestions. I'm going to look into that trigger. It ought to work nicely with SQL Server authentication. When...

The problem is the lack of object criteria against which your performance could be measured. IOW, you should be able to agree with your manager that accomplishing XYZ or...