SQL Server Performance

Cluster Question

Discussion in 'SQL Server Clustering' started by krismop, Jun 6, 2005.

  1. krismop New Member

    Hello,

    As far as performance tuning, where can I find statistics or could you offer your opinion in the following scenario.

    Which offers better performance, running One server in Active mode and another in inactive mode, each with four processors

    or

    Running both servers in active mode, each with two processors.

    Please offer an opinion if you can and a place to look for metrics.

    Thank you.
  2. Argyle New Member

    Note that the nodes are independent of each other. They can not share databases at the same time. So if you only have one database go with active/passive 4 processors.

    If you have many databases you could distribute them between two active nodes. It depends on if you have queries or other activities that could benefit from 4 CPUs.
  3. satya Moderator

    Can you also share the size of databases and their growth, so it gives more insight.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page