dbTalk Databases Forums  

SCSI Hardware RAID Enclosure Choice for use with Dell's

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss SCSI Hardware RAID Enclosure Choice for use with Dell's in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
open to suggestions
 
Posts: n/a

Default SCSI Hardware RAID Enclosure Choice for use with Dell's - 06-23-2004 , 10:56 PM






I've upgraded our SQL2k server to cluster using Dell 2650's attached to Powervault chasis -- U320 all the way through. Our db's are 90% read, and performance had degraded significantly. Anyyone able to suggest a better external raid config and still keep my u320 15k scsi disks? I see the Hp offerings, but not sure if they work with dell's. Dells only suggestion was the EMC CX400 fibre. Looked on the HCL, but didn't see any obvious choices. Assume the degradation has to do with enabling cluster mode on the Perc 4 cards.

Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SCSI Hardware RAID Enclosure Choice for use with Dell's - 06-24-2004 , 10:15 AM






You are correct. Cluster mode disables all write cache, which will cause
severe performance degradation. Unfortunately, this is essential to cluster
mode since data in write cache would be lost during a failover, causing a
corrupt database. As long as you use SCSI disks in a cluster this will be a
problem. The CX line of products uses Fibre Channel drives and the cache is
in the enclosure. Therefore write cache is available regardless of which
host is in control.

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

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

"open to suggestions" <open to suggestions (AT) discussions (DOT) microsoft.com> wrote
in message news4048111-0A5C-461F-9AFA-07F1464CA25D (AT) microsoft (DOT) com...
Quote:
I've upgraded our SQL2k server to cluster using Dell 2650's attached to
Powervault chasis -- U320 all the way through. Our db's are 90% read, and
performance had degraded significantly. Anyyone able to suggest a better
external raid config and still keep my u320 15k scsi disks? I see the Hp
offerings, but not sure if they work with dell's. Dells only suggestion was
the EMC CX400 fibre. Looked on the HCL, but didn't see any obvious choices.
Assume the degradation has to do with enabling cluster mode on the Perc 4
cards.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.