SQL Server Load Balancing and cluster solutions!

 SQL Server Load balancer cluster:Http://www.grqsh.com/index.htmBeijing glui Trend Micro Co., Ltd.

Moebius for SQL Server
As of SQL Server 2008, Microsoft has not released the Server Load balancer component and can only rely on third-party software. Fortunately, this software was written by a few people from Microsoft, which is a small coincidence. If they are from Microsoft, they do not mean that their technology is too powerful, but they use some internal interfaces of SQL Server to make the cluster very transparent, both application calls and the use of development/management personnel are the same as those of a database.
Their implementation principle is as follows: Like an SQL Server image, each database node has its own data, that is, the non-shared disk architecture. A program called "Middleware" is hosted inside the database. when data is written to each node database, causing data changes, SQL Server activates "Middleware ", middleware synchronizes changed data to other nodes. The same is true for other nodes. Because the middleware host is in the database, it can bind each synchronized session with the session of SQL Server, that is to say, it makes the user's execution and data synchronization an atomic operation to ensure that the data is consistent at all times. Therefore, the query can be performed on every machine to achieve real load balancing.