Solved

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

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Unable to access VM console from vSphere ? 2 38
Application timeout 4 45
Cloud Lab Environment for Company 5 49
VM replication scenario and caveats ? 6 51
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
Viewers will learn how the fundamental information of how to create a table.
How to install and configure Citrix XenApp 6.5 - Part 1. In this video tutorial we have explained step by step installation of Citrix XenApp 6.5 Server on Windows Server 2008 R2 is explained in this video. We have explained the difference between…

733 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