My question is, How much is going to effect?is the performance degraded to
80%...?If I use raid 10,is going to solve this problem, thank you for your
help.

What cache are you talking about? This should not be a problem with any
raid you choose.

--
Andrew J. Kelly SQL MVP


"Li" <li (AT) mach-p (DOT) com> wrote

If you are talking RAID Controller caching, its not a problem. Either turn
it off or risk crashing your DB.

Cheers,

Rod
"Li" <li (AT) mach-p (DOT) com> wrote

You will have to disable any SCSI on-board controller cache when clustering.
This will impact performance regardless of RAID type, but it is worse with
RAID-5. If you are using a Fiber-Channel array or a SAN, they typically
have their own cache that is independant of the host controller. That cache
can and should be left active. Slow performance is one reason I avoid SCSI
clusters if possible.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Li" <li (AT) mach-p (DOT) com> wrote