December 26, 2009 at 4:50 am
Hi,
In Web application, we have load balancing technology to distribute the load among the group of servers to entertain high request of HTTP request
In database, what the technology is available?
December 26, 2009 at 6:58 am
Hi Sharul,
SQL Server does not offer a complete load balancing solution out of the the box per say.
A common implementation is to use SQL Server Replication technology in order to create a distributed database architecture across multiple database servers. The web tier is then used to manage the traffic accordingly to the database tier.
For more information consult the following reference: Improving Scalability.
December 26, 2009 at 8:30 am
There is also Shared Scalable Databases (http://msdn.microsoft.com/en-us/library/ms345584%28SQL.90%29.aspx)
Or you can replicate read only data to other servers and have one central write server. As John mentioned, there is no load balancing available in SQL Server as of now.
December 26, 2009 at 9:30 am
tq for the info.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply