Question about MSSQL Replication

[Hmongkeysauce]

Let's say I want to set up transactional replication using MSSQL 2008, having the publisher, distributor, and subscriber on different physical servers. Without making any modifications to the client application, does replication help spread the read load (SELECT queries) among the publisher and subscriber?

 

[KLin]

For anyone accessing the subscriber, the select queries would be executed against the subscriber. The only load between the subscriber and the publisher would be the replication.

 

[TechBoyJK]

For anyone accessing the subscriber, the select queries would be executed against the subscriber. The only load between the subscriber and the publisher would be the replication.

Yea, to my understanding (having only really studied sql 2000) is that load balancing like that will only occur if you have a clustered setup. Your data sources are going to be defined to hit a specific server, regardless if its a subscriber, publisher, etc.

Replication does not have any inherit load balancing.

 

[Nothinman]

As TechBoyJK says, clustering and replication aren't the same thing. Queries will be executed on whichever server that user picks.