Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
siten0308
Starting Member
4 Posts |
 Posted - 2011-10-13 : 13:19:53
|
| Hello,I am new to this, and have read a nice book called "Microsoft SQL Server 2008 R2" by William R. Stanek, good book, would recommended it, anyways, the biggest thing right now I need input on is getting a database that is load balanced, I can say maybe adding more database files and distributing them across different drives would help, but I am considering replication, merge replication to be exact, we currently right now have a fail over cluster, but there are a couple of databases i see on the performance tool having a lot of work load, wondering would merge replication be a good choice, we are going to add 2 more servers, i was thinking of making one the distributor server, while the other be the subscriber and it will be all in one site. any input advice etc. would be great.Thanks |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-10-14 : 07:12:26
|
| Have you investigated what might be causing the couple of databases to under perform?If not this should be the first thing you do before going down the route of adding servers etc.----------------------------Junior DBA learning the ropes |
 |
|
|
Cindyaz
Yak Posting Veteran
73 Posts |
Posted - 2011-10-16 : 16:25:08
|
| You can use Peer to peer replication if you are considering having multiple servers for the same database. |
|
|
|
|
|
|
|
|
Sql Server load balancing