Tag Info

New answers tagged

2

Can you please look at SQL Server errorlog and see if you could find some relevant information on both Principal and mirror. Generally if SQL Server CPU utilization goes high above 50 % there can be failover. This is specifically caused by heavy load on SQL Server this is documented in Below Microsoft Web resource See 'recommendation for Configuring partner ...


0

I tried to follow the way mentioned in the link above. I am using the certificate concept. I have 3 instances on the same machine.Default one is for witness and other 2 instances are principal and mirror servers. (1) Inside witness when I am running below query: CREATE CERTIFICATE Server2_cert AUTHORIZATION login_mirroring FROM FILE = ...



Top 50 recent answers are included