1 of 1 people found this helpful
We have set-up mirroring with automatic failover on SQL 2008 R2. In general this has been working fine. We did need to extend the default SQL time-out from 10 seconds to 60, as we found 10 seconds just was not long enough and so it kept failing over regularly.
As far as failovers go, the users haven't been noticing anything when these occur - we use WebDesk with integrated authentication. The only thing I have noticed (although I haven't been able to find the root cause) is that occasionally one or more of my TPS services may stop working and I think it may be in some way linked to the failovers, but can't be certain.