0

I have a database in a high availability group with two nodes and one listener.

Several times a week, I have a problem with switchovers. The message I get is:

Stopped listening on virtual network name ''. No user action is required.

Any idea?

Improve this question
2
  • Are you sure is this the only message, is their no disconnection message in errorlog
    – Shanky
    Commented Dec 29, 2016 at 12:39
  • I have seen this happening when a state change occurs. Check the cluster logs / Windows event logs for more details. There should be messages pre this message in the error log.
    – Kin Shah
    Commented Dec 29, 2016 at 14:19

2 Answers 2

Reset to default
1

When your cluster tries multiple times to attempt a failover and it maxes out on the failover threshold value, an error that you described occurs. Basically it gives up and goes into a failed/offline state and stops listening on Virtual Network Name. To find the RCA of your issue, you need to identify the errors that occurred prior to this error. Let's us know what you see and then we can further dig into issue.

Improve this answer
0

I found out that a scheduled Job is attempting some big insert that floods one of the databases and when the CPU rises the nodes switches over.

Thank you for your interest to help :)

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.