CODEWITHSUNDEEP
sql-serversql-server-2008-r2
user741319
user741319

Reputation: 625

Parallel Processing in SQL Server 2008 R2

I want to run my 2(two) SQL Server 2008 R2 Enterprise Edition as if one server. If one server is too busy, system should direct the requests to other server. How can I do this? Thanks..

Upvotes: 0

Views: 430

Answers (2)

Shaun Stoltz
Shaun Stoltz

Reputation: 11

Look into SQL server service broker. This is an asynchronous messaging system in SQL server. There is a way to read from a queue using a stored procedure running in multiple processes

Upvotes: 1

Remus Rusanu
Remus Rusanu

Reputation: 294247

There is no such thing as you want, SQL Server does not support 'load balancing'. Active/Active clusters are about two different clusters being active on the same hosts(s).

You can scale out reads using technologies like AlwaysOn, you can scale out writes asynchronously (with eventual consistency) using sharding data in the application layer, SQL Azure Federations, Merge Replication or Updateable Subscriptions with Transactional Replication (now deprecated)

Upvotes: 1

Related Questions