We are considering implementing SQL failover clustering and I have a question about how SQL Failover clustering works with regards to performance. Specifically, we would have about 1000 dbs mounted on said cluster, and my concerns are:
Performance during a failover: Will there be an outage during the failover operation?
How long can I expect the failover to take?
I'm not sure how it's implemented, but I'm just imagining the analogy of shutting down a SQL server service on one machine, and once complete starting up on another machine. With all of these dbs, just recycling the SQL service takes about 10 minutes. Should I expect the same from the failover?