RAID FOR SQL

Hi. I've to install a server with SQL server and a RAID system. We've
installed servers
with SQL but without RAID systems. I want to know wich is the best
configuration and how many disks
to install RAID on a server wich only has to run SQL server. The RAID, must
be only for data or for
data and the operating system at time?. Thanks a lot.> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers with SQL but without RAID systems. I want to know
> which is the best configuration and how many disks to install RAID
> on a server wich only has to run SQL server. The RAID, must be only
> for data or for data and the operating system at time ?
RAID Levels and SQL Server:
http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1_87jm.asp
Comparing Different Implementations of RAID Levels:
http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1_79pv.asp|||JP,
The best practice I've heard and use myself is a separate volume for each of
the following:
RAID 1 volume for OS and executables
RAID 10 if possible (RAID 5 if not) for SQL Server data files
RAID 10 or at least RAID 1 for log files
RAID 10 or RAID 1 for tempdb
RAID 5 for backups
This is in general; sometimes variations are required depending on
requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
as RAID 1, but I can't verify that.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi. I've to install a server with SQL server and a RAID system. We've
> installed servers
> with SQL but without RAID systems. I want to know wich is the best
> configuration and how many disks
> to install RAID on a server wich only has to run SQL server. The RAID,
must
> be only for data or for
> data and the operating system at time?. Thanks a lot.
>|||Please read the documentation on http://www.baarf.com/ which explains why
RAID 5 is not a performing option.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23mYi7kH%23EHA.3856@.TK2MSFTNGP10.phx.gbl...
> JP,
> The best practice I've heard and use myself is a separate volume for each
> of
> the following:
> RAID 1 volume for OS and executables
> RAID 10 if possible (RAID 5 if not) for SQL Server data files
> RAID 10 or at least RAID 1 for log files
> RAID 10 or RAID 1 for tempdb
> RAID 5 for backups
> This is in general; sometimes variations are required depending on
> requirements. Some SAN vendors claim their RAID 5 flavors are just as fast
> as RAID 1, but I can't verify that.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
>
> "JP" <aspento_quitar_para_correo_@.arrakis.es> wrote in message
> news:OogXabz9EHA.1564@.TK2MSFTNGP09.phx.gbl...
>> Hi. I've to install a server with SQL server and a RAID system. We've
>> installed servers
>> with SQL but without RAID systems. I want to know wich is the best
>> configuration and how many disks
>> to install RAID on a server wich only has to run SQL server. The RAID,
> must
>> be only for data or for
>> data and the operating system at time?. Thanks a lot.
>>
>