Cluster Question | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Cluster Question

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.
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.

Can you also share the size of databases and their growth, so it gives more insight. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.