Solved

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

Posted on 2016-07-25
1
86 Views
1 Endorsement
Last Modified: 2016-07-27
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
1
Comment
Question by:michalek19
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 8

Accepted Solution

by:
LajuanTaylor earned 500 total points
ID: 41728332
@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

Featured Post

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
Microsoft will be releasing the Windows 10 Creators Update in just a matter of weeks. Are you prepared? Follow these steps to ensure everything goes smoothly and you don't lose valuable data on your PC.
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…
In this video tutorial I show you the main steps to install and configure  a VMware ESXi6.0 server. The video has my comments as text on the screen and you can pause anytime when needed. Hope this will be helpful. Verify that your hardware and BIO…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question