Avatar of kwh3856
kwh3856
Flag for United States of America asked on

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

Avatar of undefined
Last Comment
kwh3856

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
chapmandew

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
chapmandew

Oh, to be clear...SQL Server does NOT natively support load balancing...
kwh3856

ASKER
Thank you.  That was exactly what I needed to know.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck