Andrew Fowler-367854 (8/26/2010)
Perry, even using .net your failover might not be seamless if you are using connection pooling. Atleast that has been my experience.
I actually tested this for a customer implementation...
WITHOUT a witness server, the failover was manually initiated and the client application (a web app) took around 5 minutes to recover..
HTH