I think Load Balancing is a feature of great necessity.
Would it be probably added to other features in Next versions?
thank every one
In SQL 2005 Peer-To-Peer replication offers some of the benefits of load balancing but the load balancing bits need to be managed outside of SQL Server (like a another tier than channels/manages user connections).
|||one of most important benefit of load balncing is managing User Connection. and repliction is another Overhead ....i think load balancing is neceesory for SQL Server.|||
The is no 'easy' way to do load balancing in SQL Server and I do not think it is planned for the next release either. The question however is why do you need load balancing? SQL Server can support quite a number of concurrent users on a single box given the right hardware and correct database design.
There are ways to do load balancing through distributed partioned views for example. In case of reporting there are scalable shared databases.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
|||thank for your answer.but it is hard and expensive for many company to supply a great singel server.
this is my Idea but i think storage team know evrey thing and make best decision
thanks agin
No comments:
Post a Comment