Re: RAID and Cluster!!

First, you need to fix you SAN issues, with or without clustering SQL really
likes to have its disks online at all times.

Have you separated your Databases and Transaction Log files? RAID 1 or 10
for the Logs. Raid 5 or 10 for the Databases. Quorum & MSDTC (if required)
on its own disk subsystems of 1 GB in size.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training

"Vai2000" <nospam@xxxxxxxxxxxxx> wrote in message
news:%23Lb1UxbIGHA.524@xxxxxxxxxxxxxxxxxxxxxxx
> Hi All, Want to seek advice and experience from all of you. What is the
> recommended RAID Solution for SQL Cluster on SAN, is it RAID 1+0 or
> RAID-5?
> We just upgraded from RAID 1+0 to RAID 5 and since then we are getting
> hiccups on the Cluster. If there is any connectivity failures on the
> Drives
> (which are recovered after few mins) the Cluster goes haywire and becomes
> unavailable (for e.g. it fails to read off the Quorum Log etc...)
>
>
> Thanks in adv.
>
>


.

Relevant Pages

  • Re: The 9997th file specific DOSFS problem
    ... The average performance of accessing the raid, single file I/O, is ... The 512 bytes "tiny cache" for the FAT is very intersting. ...  The larger the cluster size, ...
    (comp.os.vxworks)
  • Re: asm on san
    ... And as I stated, the virtualization and obfuscation at the array level, including the RAID settings within the array as well as stripping within ASM and potentially IBM's SVC front-end, the RAID level is *almost* a moot point. ... I was recently involved in the implementation and support of moving a huge multiTB database from one storage vendor to another. ... The fact that it was in a RAC cluster also helped. ...
    (comp.databases.oracle.server)
  • Re: clustering
    ... E.g. in RAID you only have one PC. ... you don't have to restore whole server -- just replace the HDD. ... RAID 5 then you have at least 3 drives and if any one of those fails then ... Another thing with cluster is ...
    (microsoft.public.windows.server.general)
  • Re: SQL 2008 clustering with Windows 2008
    ... True SANs can slice logical chuinks off of physical RAID sets and present those to a host OS as a physical disk. ... to the quorum or MSDTC usage. ... from the cluster manager to add MSDTC to the cluster, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Quorum and Data on same disk
    ... I have a Dell Poweredge 2650 Cluster with PowerVault 220 ... SCSI Drive array using RAID 10. ... >>I have a 270GB RAID Array Disk configuration. ...
    (microsoft.public.windows.server.clustering)