Question regarding Quarum Drive -- sql server clustering

acmcdba68
8/30/2007 11:14:02 AM

I am in the process of implementing a SQL Server 2005 Database Cluster and
have a question regarding the Quorum drive.

Proposed Specs:

2 - Dell NX1950 "XEON Quad Core" mated to Dell MD3000 setup as such...

2 - 73GB 15K SCSI Drives = C: (Array: 1 for SQL Binaries & System)
9 - 73GB 15K SCSI Drives = E: (Array: 2 for SQL Data & Log files)

"Here's the tricky part" Can I get away with just a single 73GB 15K SCSI
Drive or not?

Thank You
--

Geoff N. Hiten
8/30/2007 3:48:16 PM

Not good.

Your OS and SQL Binaries need to be locally attached storage, NOT on a
shared storage unit.

All Cluster shared storage should have some redundancy. Lose the Quorum and
lose the entire cluster so plan accordingly.

SQL Data and Log should be on independent drive sets (different physical
drives, not just slices from a larger RAID container.)

With SQL 2005, I have been putting tempdb on its own drive set where
possible, especially on larger systems.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : Question regarding Quarum Drive