Is it possible to load balance multiple SQL 2008 Enterprise Servers
I would like to implment load balancing across mulitple SQL 2008 Enterprise servers just like you would with a Microsoft ISA server and a bunch of WEB servers. I figure you can mirror several SQL servers but I do not know how to have a front end that will load balance between the mirrored servers. If there is a third party app out there that already does this, I would like to hear about it also.
Thanks
Microsoft SQL Server 2008.NET ProgrammingDatabases