Single instance SQL server on multiple nodes?

Question

Post reply

Single instance SQL server on multiple nodes?

parissa_bakhshi

Ten Centuries

Points: 1388
More actions
February 2, 2011 at 12:26 am

#244518

Hello,
Is it possible to have an active-active cluster with a single instance of SQL server? If no, How can I increase performance by sharing load on multiple servers?
Have fun,
Parissa Bakhshi

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

M&M SSC-Insane Points: 21700 More actions · Answer 1

Using clustering you cannot do load sharing etc.

You can refer to below link on what high availability will not do.

http://www.simple-talk.com/sysadmin/general/7-things-that-high-availability-is-not/?utm_source=simpletalkExchange&utm_medium=email-sysadmin&utm_content=7ThingsHAisNot-20110117&utm_campaign=Exchange

M&M

parissa_bakhshi Ten Centuries Points: 1388 More actions · Answer 2

dear mohammed,

Thanks for your soon reply.

Ok, I got that clustering is completely difefrent from load balancing.

But, How can I:

1- Share load of one single large DB with high transaction rate on multiple servers?

2- Share multiple related DBs load on multiple servers?

M&M SSC-Insane Points: 21700 More actions · Answer 3

I am aware of Peer to peer replication topology.

You may refer to below link.

http://technet.microsoft.com/en-us/library/ms151196.aspx

M&M

Enterprise DBA SSC-Addicted Points: 478 More actions · Answer 4

>1- Share load of one single large DB with high transaction rate on multiple servers?

Oracle RAC

>2- Share multiple related DBs load on multiple servers?

Install another instance.

If one server isn't hacking it hire a performance tuning expert and tune, tune, tune.

Dan

Jeffrey Williams SSC Guru Points: 90298 More actions · Answer 5

drawlings (2/2/2011)
>1- Share load of one single large DB with high transaction rate on multiple servers?
Oracle RAC

Or - Intersystems Cache on a VMS cluster. 🙂

>2- Share multiple related DBs load on multiple servers?
Install another instance.
If one server isn't hacking it hire a performance tuning expert and tune, tune, tune.

Or, scale up the SQL Server system to meet the demand.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs