Solved

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

Posted on 2016-07-25
1
61 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
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

If we need to check who deleted a Virtual Machine from our vCenter. Looking this task in logs can be painful and spend lot of time, so the best way to check this is in the vCenter DB. Just connect to vCenter DB(default DB should be VCDB and using…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

895 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now