Clustered SQL Servers

[redlam]

Has anyone used any method of clustering SQL servers in order to increase performance?  We would like to cluster databases in an attempt to provide load balancing.  Any information on this topic would be greatly appreciated.

 

[foxdev]

Version 7's clustering only provides redundancy (failover support), not load-sharing.&nbsp;&nbsp;This may change with Win2K/SQLS2K. <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>

 

[calahans]

I agree with FoxDev - I used NT Clustering with a SS7 installation, no load balancing. MAybe you should look at replication or distributed databases <p>Cal<br><a href=mailto: > </a><br><a href= > </a><br>

 

[redlam]

Thanks for the information.&nbsp;&nbsp;All is greatly appreciated...