We have an Active-Active-Passive setup. We have two SQL instances namely SQL1 and SQL2. When we tried to failover, SQL1 SQL resource is taking more than 2 Minutes to failover where as the other one is failing over in fraction of sec. We are facing this
issue from last two days. Before that it's working fine.
We have checked whether there are any backups running which might delay the failover process, but no backups running. We have checked the DNS response time and it's very quick(same as the case of SQL1). There is very minimal IO activity on the SAN(SQL2
IO activity is more than the SQL1). Ther were no patches applied recently.
Following is our production environment.
OS : Windows 2008 X64 bit
SQL : SQL 2008 x64 bit Ent Edition
Noof CPUs : 4 (Intel quad core)
RAM : 64 GB RAM
SAN : HP EVA4450
Please let me know the factors which will delay the SQL failover process.
View Complete Post