Solved

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

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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

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 video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

815 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

12 Experts available now in Live!

Get 1:1 Help Now