<div>
Oh, to be clear...SQL Server does NOT natively support load balancing...
</div>


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

<div>
Thank you. &nbsp;That was exactly what I needed to know.
</div>


Thank you.  That was exactly what I needed to know.

<div>
<div class="content wysiwyg-content">
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. &nbsp;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. &nbsp;If there is a third party app out there that already does this, I would like to hear about it also.<br />
<br />
Thanks
</div>
</div>


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

Is it possible to load balance multiple SQL 2008 Enterprise Servers

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.