Windows and SQL failover cluster with different cores


  • I am trying to build a SQL 2012 failover cluster with Windows 2012. This will be a AAAP cluster. Can I build the 3 active nodes with different cores and RAM as followin or all 3 nodes have to be identical?

    A1 - 32 cores 64RAM, A2 - 16 cores 32RAM, A3 - 16 cores 16RAM


    • Edited by SQLWill88 Wednesday, July 24, 2013 3:03 PM
    Wednesday, July 24, 2013 3:00 PM


  • Hello,

    IMHO they should be roughly the same if not identical - but that won't stop you from having different amounts of CPU/Ram per node. You can absolutely build what you are proposing - I would add a startup procedure inside of the instances and have them check the # of CPUs and Amount of Ram and configure themselves accordingly.


    Sean Gallardy | Blog | Twitter

    Wednesday, July 24, 2013 6:31 PM