November 14, 2006 at 4:29 pm
Hi All,
I want to test an ETL application to run on 2 physical servers rather than 1 physical server, I was wondering if anyone knew anything about projects like this or point me to websites/links that would help.
I am not sure if this topic is related to network load balancing, clustering etc.
Please advice.......
November 14, 2006 at 11:38 pm
There is nothing specific to any technologies with respect to Microsoft, as I believe even in an NLB cluster SQL Server still only has one node servicing all clients. In a normal cluster, that is certainly the case. SQL Server is built for scale up, not scale out.
SQL Server 2000 High Availability Series: Implementing Network Load Balancing
K. Brian Kelley
@kbriankelley
November 15, 2006 at 5:39 am
Hi
Thanks for your reply, I think I am being misunderstood here, basically all I wanted to know was whether it was possible to make my application more scalable by running it on 2 physical servers rather than one.
If this is possible, what sort of technology should I be looking at implementing, clustering has been put forward by Brian, but I was under the impression that Clustering was for redundancy purposes which falls under the same category as log shipping (i.e they are all redundancy techniques).
The idea I have is that, a SQL server instance over 2 servers will make the ETL code run faster.
Please advice.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply