Load Balance Clustering on 2005?

Hot Topic

How to restore SQL 2000 DB to SQL 2005
Different Execution Plans -> Same Query, Same Database, Different SQL Server Install
Building a time sensitive full-text search
Duplicate Dimension Members
SSIS Conditional Flow?
Dependent report parameters help
Missing data with SSAS cube as a report data source
SQL server configuration manager can to other instances of SQL server
Database Schemas and "This statement has attempted to access data whose access is restricted by the assembly."
Saving SSIS results to Log or text file using dtexec

SQL Server

Analysis Services Project - A connection cannot be made. Ensure the server is running.
Connecting to Oracle on 64-bit (x64) machine
Error rsFailedToDecryptConfigInformation
Accessing from desktop - path not found.
Flat file source not option for importing data
SQL Server 2000
Compare Data Before Inserting
Problem adding Annotations to KPIs
RDA problem
creating users in sql eypress

Load Balance Clustering on 2005?

My company is planning on using a datacenter for our customers.  These are manufacturing plants from which we collect batch and trend data (currently stored in SQL Server)

If we move to a centralized database model we may need Load Balancing.   I  read that SQL 2005 will accommodate this so I called MS Support and no one could confirm this.

My dilemma is that I need to report upon what our options are for the datacenter.  So I need to know if load balancing will be an offering of SQL 2005.

Answer this question

Load Balance Clustering on 2005?

  • EvilMonkeySlayer

    SQL不支持 均衡的 置, 支持故障 移.如果想 的 ,需要其他的 硬件和其他的配置可以 一定程度上的 均衡.如果想提高I/O性能可以 一下SAN存 网 ,如果 CUP等的性能可能需要 分 或者 像或者复制等技 ,使 据在其他服 器上保持一致的副本,然后在WIN上 均衡.或者 有其他的 法.目前我知道的就 些.

  • Benny Samuelsson

    Thanks for the clarification. 

  • KirkHaselden

    Hi Dave -

    Yep, that one Smile Was it really that long ago


    Don (DonV)



  • RaminRow

    Don Vilen - professor at CSU Chico circa 1982 - that Don Vilen


  • Salam

    SQL Server 2005 provides failover clustering, not load-balancing clustering.

    Network Load-balancing in Windows works well with multiple read-only servers each containing the same data, but this is not provided directly by SQL Server.

    SQL Server 2005 has several features that provide increased scalability (table partitioning, SQL Server Service Broker, XML indexes, query notifications, CLR stored procedures, and others), enhancing the scale-up abilities and further reducing the need for such load-balancing capabilities, but no, load-balancing is not provided.

    Don

  • Load Balance Clustering on 2005?
Answer this question