Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / January 2006

Tip: Looking for answers? Try searching our database.

RAID and Cluster!!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Vai2000 - 25 Jan 2006 14:38 GMT
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.
Vai2000 - 25 Jan 2006 14:43 GMT
Env:
Win2000 Adv Server SP4
SQL2000 SP4

> 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?
[quoted text clipped - 4 lines]
>
> Thanks in adv.
Rodney R. Fournier [MVP] - 25 Jan 2006 18:11 GMT
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

> 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
[quoted text clipped - 6 lines]
>
> Thanks in adv.
Michael Hotek - 25 Jan 2006 18:20 GMT
That's not an upgrade, it is a reconfiguration.  They do completely
different things.  By RAID 1+0 do you mean a stripe of mirrors or a mirror
of stripes?

In either case, the answer is, I don't know.  RAID5 gives particular levels
of redundancy while incurring a performance impact for certain types of I/O
patterns.  A mirror of stripes gives equivalent redundancy to RAID5 without
having quite a much of a performance impact on certain types of I/O
patterns.  A stripe of mirrors gives much greater redundancy than the other
two and generally better performance as well.  But, if you are saturating
the I/O channel or stuffing all of your data on a tiny subset of the drives
in the SAN, it really isn't going to matter very much.  The recommendations
also vary depending upon whether you have an access pattern that looks like
"tradional OLTP", "traditional DW", or a mix of the two.

Regardless of the performance characteristics, neither one is going to be
more stable than the other in your case.  If the SAN drives disconnect, it
doesn't matter if it is a cluster or a standalone SQL Server, it isn't going
to like it.  You have to fix the errors on your SAN that are causing the
disconnects first.  If those aren't fixed, there isn't anything you are
going to be able to do to make the system stable.

Signature

Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject.  It does not represent the views of any other person
or entity either by inference or direct reference.

> 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
[quoted text clipped - 6 lines]
>
> Thanks in adv.
Anthony Thomas - 26 Jan 2006 03:07 GMT
Not to mention that unless you have proper host isolation in the SAN, you
are going to run into severe spindle contention, even if this particular
host's channels are not saturated.

Anthony Thomas

> That's not an upgrade, it is a reconfiguration.  They do completely
> different things.  By RAID 1+0 do you mean a stripe of mirrors or a mirror
[quoted text clipped - 28 lines]
> >
> > Thanks in adv.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.