<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
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.<br />
I am planning to use MS SQL 2012 &nbsp;with two node failover cluster and external storage (SAN, NAS, etc.)<br />
I am looking for High availability and Performance .<br />
<br />
In current MS SQL 2008 r2 environment we have huge &nbsp;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.<br />
<br />
I am looking for Windows Server 2012: Building a Two-Node Failover Cluster with High availability and Performance <br />
Can anyone &nbsp;help &nbsp;to create MS SQL system specs that are reliable with great performance and with reliable storage that would work well with clustering. <br />
<br />
<br />
Thank you, Michal
</div>
</div>


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

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Windows Server 2012 is the server version of Windows 8 and the successor to Windows Server 2008 R2. Windows Server 2012 is the first version of Windows Server to have no support for Itanium-based computers since Windows NT 4.0. Windows Server 2012, now in its second release (Windows Server 2012 Release 2) includes Foundation, Essentials, Standard and Datacenter, and does not support IA-32 or IA-64 processors.

Windows Server 2012

VMware, a software company founded in 1998,  was one of the first commercially successful companies to offer x86 virtualization. The storage company EMC purchased VMware in 1994. Dell Technologies acquired EMC in 2016. VMware’s parent company is now Dell Technologies.

VMware has many software products that run on desktops, Microsoft Windows, Linux, and macOS, which allows the virtualizing of the x86 architecture.  Its enterprise software hypervisor for servers, VMware vSphere Hypervisor (ESXi), is a bare-metal hypervisor that runs directly on the server hardware and does not require an additional underlying operating system.

VMware

Virtualization is the act of creating a virtual (rather than actual) version of something, including (but not limited to) a virtual computer hardware platform, operating system (OS), storage device, or computer network resources. Virtualization is usually the creation of a system that executes separate from the underlying hardware resources, or the creation of an entire desktop for systems located elsewhere, similar to thin clients.

Virtualization

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.