<div>
Hi,<br />
I want perfomance and with RAID10 I also have redundancy, when I configure my monitoring.
</div>


Hi,
I want perfomance and with RAID10 I also have redundancy, when I configure my monitoring.

<div>
I plan with this Raid configuration for my SQL Server:<br />
<br />
Each Raid set is physically separated.<br />
<br />
OS - Raid 1 with SATA 15k disks<br />
DATA - RAID 10 with SATA 15k disks<br />
LOGS - RAID 10 with SATA 15k disks<br />
TEMPDB - RAID 1 with SSD´s<br />
BACKUP -RAID 1 with SATA 15k disks
</div>


I plan with this Raid configuration for my SQL Server:

Each Raid set is physically separated.

OS - Raid 1 with SATA 15k disks
DATA - RAID 10 with SATA 15k disks
LOGS - RAID 10 with SATA 15k disks
TEMPDB - RAID 1 with SSD´s
BACKUP -RAID 1 with SATA 15k disks

<div>
ok then I can ask for some quotes from different vendors.
</div>


ok then I can ask for some quotes from different vendors.

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I want to buy new SQL servers.<br />
I want to isolate the data with different raid sets.<br />
<br />
Which Raid is recommended when I go for SQL2012 or 2014 ?<br />
<br />
I want to separate :<br />
<br />
OS<br />
DATA Files<br />
LOG Files<br />
TEMPDB<br />
Backup<br />
<br />
Which has the best perfomance ?
</div>
</div>


Hi Experts,

I want to buy new SQL servers.
I want to isolate the data with different raid sets.

Which Raid is recommended when I go for SQL2012 or 2014 ?

I want to separate :

OS
DATA Files
LOG Files
TEMPDB
Backup

Which has the best perfomance ?

new SQL server 2012 and Raid Sets

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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

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

RAID stands for Redundant Array of Independent Disks.

RAID is data storage technology that allows multiple drives to be used together as a single virtual drive for reasons such as fault tolerance, reliability and performance. 

There are several different levels of RAID that determine how the data is stored and the level of redundancy achieved across the drives.