SQL Server active/active node clustering

20 pts.
Tags:
SQL Server 2005
SQL Server 2005 Database
SQL Server database
I need to scale my applications to support the future volumes. We are using sql server 2005 service pack 2, on a active and passive node cluster environment. Can I add another active node to the cluster and create a grid environment to scale my enviornment, without impacting any of my current applications/sql statements/stored procedures? If yes, can you pleaese guide me with the steps to do that?

Software/Hardware used:
SQL Server 2005 service pack 2, SAN, 32 BIT

Answer Wiki

Thanks. We'll let you know when a new response is added.

No, SQL Server does not support that. You can use a federated databases but this is very complex to do, and to be frank odds are your database and application aren’t big enough to need to do this.

If you have a 32bit SQL server you should be upgrading to a 64bit server, adding more RAM, and more CPUs to the server.

Can you describe your systems in more detail? What kind of servers do you have? What sort of workload do you have? How many transactions per second do you support?

Have you already fixed any indexing problems that exist?

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ndtvenkat
    [...] 9. Do you have any additions to a discussion about SQL Server active/active node clustering? [...]
    0 pointsBadges:
    report
  • Ndtvenkat
    We are using HP proliant DL 380 G5. Cluster was set up on CISCO LB 11500 We have 0.5 million consumers active consumers and SAGE CRM is running on these servers and not able to cope-up the volumes to any extent. We have evaluated creating partitions and tried to fine tune the application. Very little improvement is seen. Other than load sharing do you suggest any other approach?
    20 pointsBadges:
    report
  • Denny Cherry
    Where is your bottleneck? Is it IO, RAM, CPU load, CPU threads, bad indexes?
    66,130 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following