Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a SQL server 2008 R2 database with 2 schemas, i need to enhance the performance of the server so we plan to cluster the DB, we will have 2 nodes . is it possible to separate each scheme so each node will have one schema

share|improve this question

No. Simple like that. The unit of separation is a database, not a schema. And clusters are active/passive.

share|improve this answer

You can build an active/active cluster, which with SQL Server basically means you have two separate SQL instances with it's own name an virtual IP address. Each instance can hold one of your schemas.

Some caveats to keep in mind:

  • Note you need to fully license both cluster nodes in this scenario.<
  • You need to have enough shared storage for the two dedicated SQL instances as LUNs can't be active on more than one node.
  • You can only use half the memory on each node, in case of box failure you'd need to run both instances on one node.

There are good guides on the net how to configure this, it's a bit more complex than a normal active/passive cluster.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.