select operation drop when SQL server AOG failing over.

hi all,

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 。)

Open in new window



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?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
How are you connecting to the database Replica? Can you post the current connecting string that you're using?
Also, how many Replicas the database has?
0
marrowyungSenior Technical architecture (Data)Author Commented:
"Also, how many Replicas the database has?"

1  x primary and 2 x secondary.

"How are you connecting to the database Replica?"

via connector.

"an you post the current connecting string that you're using?"

Server= tcp:SQLAOGlistener,1433; Trusted_Connection=true; Database=WideWorldImporters;  MultiSubnetFailover=True; ApplicationIntent=ReadOnly;

Open in new window

0
Vitor MontalvãoMSSQL Senior EngineerCommented:
1  x primary and 2 x secondary.
From which Node to which did you failed over the AOG?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

marrowyungSenior Technical architecture (Data)Author Commented:
login to primary and failover to secondary.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
I've already posted this article in your another question but I think they are related so check if it helps.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
tks.
0
marrowyungSenior Technical architecture (Data)Author Commented:
i might come back.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.