SQL 2005 Standard.
Hi I would like to find the best approach to load balancing some SQL 2005 Servers taking in mind also the future scaling out of tens or hundreds servers.
I found this article: http://goo.gl/zP1R that writes about P2P replication, Table partitioning and Database mirroring but:
- P2P replication is limited to 12 servers
- table partitioning is not related to our case
- From what I know Database mirroring is only a high-availability solution, isn't it ?
What do you think ? Which is the best solution ?
Is SQL 2008 better in this area ? Could I upgrade to better meet these points ?
View Complete Post