Solved

RAID setup recommendations for SQL Server machine.

Posted on 2007-03-28
7
1,871 Views
Last Modified: 2008-03-03
I am looking for recommendations on what type of RAID system we should implement for this server and (why).

Here is the situation:
1. Windows NT 2000 server - Applications: SQL Server 2005, Great Plains, miscellaneous utilities (our Exchange / Mail is a different server)
2. All SQL server Tables, GP tables and data
3. All user's (50) document folders, they store all their documents on this server.

Here's what I would like to achieve:
1. If we crash, instant or easy restoration of the operating system, all configuration, SQL Server and GreatPlains configurations.
2. Easy restoration of 'data' files.

We already own:
Adaptec 3200s, 2 channel Scsi RAID controller
8 identical 32gig SCSI drives .

My 3rd party network vendors are suggesting 2 Arrays of 4 drives each (32gigs), both would be RAID LEVEL 5.

Channel 1would have the OS in one partition, SQL server and GP in another.
Channel 2 would have 'data' files only in one partition, a second partition for 'other' stuff.

Can / should I 'ghost' or image the operating system and SQL installtion to another drive on our network as a precaution?  Configuration does not change from day to day.





0
Comment
Question by:Volibrawl
  • 3
  • 3
7 Comments
 
LVL 3

Accepted Solution

by:
dglenp earned 400 total points
ID: 18810036
I set up both my SQL Server and Exchange Server boxes with RAID 1 and RAID 5.  In your scenario, I would set up a RAID 1 array using 2 drives for the OS and program files (I also put the SQL transaction logs on this array).  Set up a RAID 5 array using 4 drives for data (SQL/GP data and user files).  Configure 1 of the remaining drives as a hot spare that can be immediately put to use by the controller in the event one of the other drives fails.  Put the 8th drive on the shelf as a spare part.  I recommend this mainly because of the spare parts issue.  I had a RAID 5 array with three drives go down once when TWO of the drives failed within seconds or minutes of each other.  The 4-drive array for data is a better setup.  But I think a 4-drive RAID 5 for the system partition is a bit over done.  I'd prefer to have a spare drive on the shelf.  IMHO.

The 'ghosting' issue depends on your down-time tolerance.  With RAID arrays and spare drives, your data is fairly secure...unless the 3200s controller or the motherboard fails.  Then all the happy data on your fault-tolerant RAID arrays is useless unless you have spare parts at hand or a stand-by server available.  You say you want to achieve "instant or easy restoration."  You will have to consider whether your environment requires high availability options such as server clusters.  As far as recovery goes, if you have spare parts and good backups, you can be back on line having lost little or no data.  However, in a worst case scenario, without high availability, it may take hours to do (or a day or two if you have to order a new server or motherboard, etc.).

HTH,
dglenp
0
 
LVL 9

Author Comment

by:Volibrawl
ID: 18811185
Thanks  ...

Your suggestion is well-taken and where I would like to go with my setup.

Right now, my network guys have returned the server (bootable), with updates, Backup tape, etc.
The setup is 2 RAID 5's.  OS is on the first Array
Data (preserved) is on the second Array.

Is there a way to "break up" Array0 (4 drive RAID5) so I can re-configure it as 2 RAID1's ? (consistent with your idea adn M$ suggested setup for GP.)

Bear in mind:
1. I don't want to have to re-install NT and all the updates from scratch
2. I don't want to chance losing my data (on Channel2 RAID5).

M$ suggests:
RAID 1 for operating system and applications (2 disks)
RAID 1 for SQL database log files (2 disks)
RAID 5 (4 disk minimum) for SQL data files
RAID 1 for TempDB (2 disks) - OPTIONAL, but recommended - maybe later ...
0
 
LVL 3

Expert Comment

by:dglenp
ID: 18811595
If you split the 4-disk RAID 5 into two RAID 1's, you will lose the data.  You may already know that RAID 5 requires at least 3 drives to set up.  It can run with degraded performance if one drive fails, but it takes 3 to set up.  RAID 1 is simply mirroring, so it only requires 2 drives.  To re-configure the server you could Ghost the channel 0 volume or make a complete backup using some other tool, re-configure the array, then restore the image onto one of the RAID 1 arrays and make it the boot volume.  The backup and restore would be good disaster recovery practice anyway.

Through all of this, the data on the other volume wouldn't be disprupted.
0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 9

Author Comment

by:Volibrawl
ID: 18812310
Thanks, that is exactly what I am doing now...

1. Mirroring our current C: drive onto an IDE drive.
2. Mirroring our current 2nd RAID array (Array1 RAID5- Our data) onto the same IDE drive (for failsafe BU).

Once we are comfortable that we still have all our data on the IDE, we can break apart our OS RAID5 and reconfigure it into the 2 RAID1s.

Then we will try to boot from the IDE and mirror the OS back to the newly created  Array.
Working on it right now  ..

I need to look at "how to ghost and restore from Ghost".  Will be my next question...
0
 
LVL 3

Expert Comment

by:dglenp
ID: 18813519
Depending on which edition of Ghost you have, it should allow you to boot from the CD and copy from volume to volume.  You may have completed the task by now, though.  It's late here.  Just checking the update...
0
 
LVL 4

Assisted Solution

by:_Mr_Limo
_Mr_Limo earned 100 total points
ID: 18821540
Best way to minimize possible down time is to have the 2 RAID 5's - one with the OS (3 drives) and the other (4) drives as the data - a RAID 1can and will most likely fail - if the failure of the one drive causes Media Damage on the other drive at the same time, you have 2 dead drives (it happens all the time).  in a RAID 5, which provides the most fault tolerance, you can have 1 (ONE) drive fail in the array & not lose the use-ability of the device.  It's not possible for 2 drives in a raid 5 to fail and NOT lose data.  Always have an alternate backup - a current Ghost image is always your best bet.  RAID 1 does not give enough fault tolerance for the o.s., if it's a necessary server.  
0
 
LVL 9

Author Comment

by:Volibrawl
ID: 18823278
Always anxious to hear logically supported recommendations .....
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration, of the HP EVA 4400 SAN Storage. The name , IP and the WWN ID’s used here are not the real ones. ABOUT THE STORAGE For most of you reading this, you …
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now