When you combine failover clustering and database mirroring in SQL Server, you need to change the mirroring partner timeout value so that the local cluster gets a chance to fail over before database mirroring fails over. I'm curious as to what people are doing when combining these technologies - I teach various HA classes and this is not too common a combination.
Here are my questions IF you are using failover clustering and database mirroring combined. If you could answer them all in each response, that would be very useful to me. I don't need an explanation of why things need to be changed or how the technologies work - I used to own them both when at Microsoft - I'm interested in industry practices now the possibility of marrying them has been out there for 4 years.
1) how long, on average, does it take for a clustered SQL Server instance to fail over for you? (I know it depends on how much crash recovery is required, but what's an average for you?)
2) for these same instances, what do you set the mirroring partner timeout to?
3) are you comfortable with the fact that a real cluster outage could occur and it may be quite a while until mirroring notices that the failure has occured because you've bumped the mirroring partner timeout up?
Thanks for all responses!