RE: SQL Cluster on SAN

From: Alfred XYZ (anonymous_at_discussions.microsoft.com)
Date: 11/26/04 

Date: Fri, 26 Nov 2004 00:42:30 -0800

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
>
>.
>

Relevant Pages

  • Re: SQL 2000 + W2K Upgrade
    ... Should I deal with the OS change first ... or the SQL change first? ... a mirrored array. ... sizes of data drives; backup drives; quorum drives, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Multiple Arrays Single controller
    ... If you are using hardware to manage the drives then in this case the OS ... Generally the more drives you are using in an array, ... controller/drives can keep up with the data. ... Just a DC, Exchange, SQL or all of the above. ...
    (microsoft.public.win2000.advanced_server)
  • Re: RAID 5 Disk Array
    ... disk failure, you can use an online spare or you can use ADG ... RAID 5 array using the HP controller ... 12 146GIG Drives in the array ...
    (microsoft.public.windows.server.general)
  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Newbie - SAN Advice
    ... I have not used that particular unit, bit it does meet my basic criteria of having the controllers and cache on-board the array. ... Senior SQL Infrastructure Consultant ... A SAN generally has gigabtes of cache and uses large internal block sizes ... The SAN or Smart array will dictate what internal connection the disks have. ...
    (microsoft.public.sqlserver.clustering)
Quantcast