I have same similar kind of issue when we want to failover to secondary replica in ag that is manual failover . we received an error with wsfc 5016 with sql server 41018 error . we are unable to failover.
Hi Vamsi, Apart from jobs, how specific applications let's say some readable applications can connect to secondary replicas to increase performance? How they identify the secondary node to connect and perform the task Can you please tell me
You need to use Read only routing. once we configure then reporting workloads can be diverted with the help of Application Intent=Readonly. But we need to have license to make use of secondary replicas for reporting.
I have same similar kind of issue when we want to failover to secondary replica in ag that is manual failover . we received an error with wsfc 5016 with sql server 41018 error . we are unable to failover.
Thanks for sharing bro.
hi dear How do I know if SQL Server needs more memory?
Hi Vamsi,
Apart from jobs, how specific applications let's say some readable applications can connect to secondary replicas to increase performance? How they identify the secondary node to connect and perform the task
Can you please tell me
You need to use Read only routing. once we configure then reporting workloads can be diverted with the help of Application Intent=Readonly. But we need to have license to make use of secondary replicas for reporting.