when I doing a select (*) operation against a MS SQL server 2016 AOG with 2 x read-only load balanced replica, I tried to failover to other node and see what will happen to the select (*) operation,
I got this:
Msg 10054, Level 20, State 0, Line 14
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 。)
any reason why the select (*) is not keep going but return an error during AOG failover ?
I tried that using server local version of SSMS, it seems it is the SSMS version problem! What I found out is sth else, the AOG failover will WAIT until the existing select query is finished, not that good, right?