SQL mirror fails over often

I set up SQL mirroring with a witness server on Server 2008 R2 with SQL 2008. I can manually fail over fine from one to the other and everything syncs and works. However, for some reason the servers seem to fail over to the mirror a couple times a day. The principal is not being restarted and seems to be running fine. The principal is a VM, the mirror and witness are not if that matters. What can cause failover so often
LarryDAHAsked:
Who is Participating?
 
Ramesh Babu VavillaConnect With a Mentor Commented:
increase the time out and check the peformance of the
0
 
LarryDAHAuthor Commented:
Where do you change the timeout?
0
 
Ryan McCauleyData and Analytics ManagerCommented:
Is there a network interruption that precedes the failover event? Can you set up a window that pings all the servers involved and then check it for odd network performance at the time of the next failover?

A failover is initiated if the witness loses contact with the principle but maintains contact with the mirror, so it's possible it could be VM-related (or more accurately, related to problems on the VM host server).
0
 
LarryDAHAuthor Commented:
Network activity seems normal otherwise, no interruptions.
0
 
LarryDAHAuthor Commented:
Changing the timeout can only be done thru SQL, that seems to be working.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.