Post reply

Load Balance/Performance Balance

  • January 26, 2004 at 4:51 pm

    #84553

    I would like to know what other companies have implemented for load balancing SQL Server.  We are moving from Oracle 9i to SQL Server 2000 or 2003 and the 2 Terabytes of data will reside on an EMC SAN.  In my research I have found the following:
     
    Microsoft Cluster Services (MSCS) - Does not provide load balancing, only failover.
     
    Network Load Balancing - This solution only works for read only databases. 
     
    Federated Servers - There are two flaws:  (1) Since multiple machines process one query, the result of that query cannot be assembled until the slowest database in the federation has completed processing its portion of the view.  So, if there are several quad processor servers and one dual processor server, the query can only execute at the speed of the dual processor.  (2) Referential Integrity Constraints can't be implemented since the data is split between separate servers. 
     
    Can anyone provide information on the load balancing solution at their site?
     

  • January 26, 2004 at 5:34 pm

    #491695

    SQL Server doesn't really have any good load balancing solutions. What type of load balancing do you need? In an OLTP environment?

    At PASS I saw a vnedor building hardware boxes to process queries, but they get expensive fast. Almost linear scalability, but not really load balancing.

  • January 27, 2004 at 12:07 pm

    #491811

    The environment will be OLTP.  I am wondering what sort of SQL Server solutions other companies are using for data that is 1 Terabyte and up.  Filegroups, federated servers?  Just looking for some direction.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply