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.
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|||Thanks for the clarification.|||SQL不支持负载均衡的设置,仅支持故障转移.如果想实现的话,需要其他的软硬件和其他的配置可以实现一定程度上的负载均衡.如果想提高I/O性能可以试一下SAN存储网络,如果实现CUP等的性能可能需要实现分区或者镜像或者复制等技术,使数据在其他服务器上保持一致的副本,然后在WIN上实现负载均衡.或者还有其他的办法.目前我知道的就|||Don Vilen - professor at CSU Chico circa 1982 - that Don Vilen?|||
Hi Dave -
Yep, that one 
Was it really that long ago?
Don (DonV)
No comments:
Post a Comment