March 10, 2003 at 7:40 am
It would like to know if through the implementation of cluster of SQL 2000 I get load balacing? If not, I must implement Distributed Partitioned Views? Which impact that I will have in the system of the user, is tranparente, or must modify for example the programming code?
March 10, 2003 at 8:17 am
Clustering SQL Server will not give you loadbalancing, only fail-over. With Distributed Partitioned Views (DPV) you don't have to modify application code as this is completely transparent to the application. However, it might still be a godd thing to modify applications anyway so that they access the instance with the partition that contains the data sought. That way the server won't need to make a distributed call to the other server(s) in order to return the results to the app. This is not always possible of course..
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 10, 2003 at 5:53 pm
you don't have to modify the code but it could give you an opprotunity to shape traffic so no one server has to act as a director. A good example of DPV would be adding a new server every year for large time or date oreinted data you may not need the legacy data all the time but some users work almost always with the older data. As the new data set comes on line current people move to the new server while people that work with the older set stay on the server where their data is. Everyone still has access to the data but they are closer to it depending on need.
Wes
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply