Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
m.esteghamat
Starting Member
47 Posts |
 Posted - 2015-02-15 : 06:46:17
|
| HiI confused between automatic redirection and automatic failover.Dose redirection , run after automatic failover?Dose automatic failover run loanly? in which events ?Dose automatic Redirection run loanly? in which events ?Thank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-02-16 : 12:38:08
|
| What techonology are you referring to? What is "loanly"?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
m.esteghamat
Starting Member
47 Posts |
Posted - 2015-02-17 : 00:36:27
|
| Availability Group .No I dont want Use It Aloanly ?I asked Why they are seperated ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-02-18 : 12:34:01
|
| I don't understand your post. But let me talk about AGs for a bit and hope it addresses your questions. When a failover occurs and if the applications are pointing to the AG listener, the applications will automatically be redirected to the AG's new primary instance.A failover can occur for many, many reasons. Here are some reasons: network issue, database files go offline because of a disk issue, Windows crashes, etc. If the cluster loses quorum due to any of these issues, a failover will occur. Quorum is dependent on the votes. If you have 2 nodes in the cluster, you will have a third resource that gives the cluster quorum. Sometimes that third resource is a file share on a another server, sometimes it's a SAN drive. If the inactive node goes down, you still have quorum since you still have two voting members available. For read-intent workloads, the primary instance will redirect those queries to the read-only instance(s). Which one it goes to is dependent on the read-only routing list. I still don't know what you mean by "loanly".Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
difference "Automatic Failover" With Redirection