Hi,
MSA1000 supports ADG RAID that allows at most 2 physical
disks failed without loss of data. ADG array is formed by
at least 4 disks, which offers available sizes of 2 disks,
with 5 has 3, with 6 has 4, and so on.
In my company, all logical drives for SQL data, quorum and
MSDTC are created on ADG RAID drives for optimal
redundancy.
In contrast, for log files, use 0+1 RAID type for higher
rate of write I/O. (MSA1000 can create 0+1 array with 2
physical disks)
Both 0+1 drive and ADG drive are created on seperate array.
In my case, 4 drives forms ADG while 2 drives forms 0+1.
Finally, my system have 2 clustered SQL servers sharing
the same MSA1000. Always create arrays specific to the
services. This could prevent degrade of performance on
both services, especially signficant to collect
information of performance log. In your case, don't put
files of SQL server and Exchange on the same arrays.
My final conclusion, you should create 2 arrays: One
always creating ADG drives, for quorum, MSDTC, SQL server
data, tempdb and SQL & Exchange install. One creating 0+1
drive for SQL server transaction log and exchange log
Hope this help. ^^
[quoted text, click to view] >-----Original Message-----
>Here are the possible shared logical drive requirements
that I'm aware of:
>* Cluster Quorum
>* MS-DTC
>* SQL T-Log(s)
>* SQL TempDB
>* SQL Data drive(s)
>* Exchange log
>* Exchange data
>
>Option A
>2x36GB 15K RAID 1 (A/B buses) - 1 LUN - Quorum
>6x36GB 15K RAID 0+1 (A/B buses) - 4 LUNs - MS-DTC,
Exchange logs, SQL logs,
>TempDB
>2x36GB 15K online hot spares (one each A/B buses)
>
>12x146GB 10K RAID 0+1 (C/D buses) - at least 3 LUNs
(Exchange data, SQL
>data, TDB data)
>2x146GB 10K online hot spares (one each C/D buses)
>
>SQL performance and scalability is primary concern.
Please advise if this
>configuration is optimum. If not, any recommendations?
>
>Thanks in advance! - rg
>
>.
!!!Correction.!!!
My final conclusion, you should create 4 arrays: One
always creating ADG drives, for quorum, MSDTC, SQL server
data, tempdb and SQL install.
One creating 0+1
drive for SQL server transaction log
Two for Exchange data and log respectively.
[quoted text, click to view] >-----Original Message-----
>Hi,
>
>MSA1000 supports ADG RAID that allows at most 2 physical
>disks failed without loss of data. ADG array is formed by
>at least 4 disks, which offers available sizes of 2
disks,
>with 5 has 3, with 6 has 4, and so on.
>
>In my company, all logical drives for SQL data, quorum
and
>MSDTC are created on ADG RAID drives for optimal
>redundancy.
>
>In contrast, for log files, use 0+1 RAID type for higher
>rate of write I/O. (MSA1000 can create 0+1 array with 2
>physical disks)
>
>Both 0+1 drive and ADG drive are created on seperate
array.
>In my case, 4 drives forms ADG while 2 drives forms 0+1.
>
>Finally, my system have 2 clustered SQL servers sharing
>the same MSA1000. Always create arrays specific to the
>services. This could prevent degrade of performance on
>both services, especially signficant to collect
>information of performance log. In your case, don't put
>files of SQL server and Exchange on the same arrays.
>
>My final conclusion, you should create 2 arrays: One
>always creating ADG drives, for quorum, MSDTC, SQL server
>data, tempdb and SQL & Exchange install. One creating 0+1
>drive for SQL server transaction log and exchange log
>
>Hope this help. ^^
>
>
>>-----Original Message-----
>>Here are the possible shared logical drive requirements
>that I'm aware of:
>>* Cluster Quorum
>>* MS-DTC
>>* SQL T-Log(s)
>>* SQL TempDB
>>* SQL Data drive(s)
>>* Exchange log
>>* Exchange data
>>
>>Option A
>>2x36GB 15K RAID 1 (A/B buses) - 1 LUN - Quorum
>>6x36GB 15K RAID 0+1 (A/B buses) - 4 LUNs - MS-DTC,
>Exchange logs, SQL logs,
>>TempDB
>>2x36GB 15K online hot spares (one each A/B buses)
>>
>>12x146GB 10K RAID 0+1 (C/D buses) - at least 3 LUNs
>(Exchange data, SQL
>>data, TDB data)
>>2x146GB 10K online hot spares (one each C/D buses)
>>
>>SQL performance and scalability is primary concern.
>Please advise if this
>>configuration is optimum. If not, any recommendations?
>>
>>Thanks in advance! - rg
>>
>>.
>>
>.
Don't see what you're looking for? Try a search.