I am planning to build new MS SQL environment and I need help suggestions what the specs of the physicals servers should be as well as storage.
I am planning to use MS SQL 2012 with two node failover cluster and external storage (SAN, NAS, etc.)
I am looking for High availability and Performance .
In current MS SQL 2008 r2 environment we have huge Data Bases that are heavily use everyday 24/7. Over 2000 internal users are accessing data bases. Over 200 developers constantly are working and running queries.
I am looking for Windows Server 2012: Building a Two-Node Failover Cluster with High availability and Performance
Can anyone help to create MS SQL system specs that are reliable with great performance and with reliable storage that would work well with clustering.
Thank you, Michal