Windows Server 2012: Building a Two-Node Failover Cluster with High availability and Performance

Hi

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
michalek19Asked:
Who is Participating?
 
LajuanTaylorCommented:
@michalek19 -

Since every environment is different, I recommend that you first take a look at the following Microsoft documentation specific to SQL Server 2012. It should provide you with a good general sense to get your project going.

Before Installing Failover Clustering
https://msdn.microsoft.com/en-us/library/ms189910(v=sql.110).aspx

High Availability Solutions (SQL Server)
https://msdn.microsoft.com/en-us/library/ms190202(v=sql.110).aspx

Failover Clustering Hardware Requirements and Storage Options
https://technet.microsoft.com/en-us/library/jj612869(v=ws.11).aspx
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.