HP E200i Controlller RAID Configuration fon Win2008 Ent, Sql Server, IIS Apps etc need opinion

Posted by mn on Server Fault See other posts from Server Fault or by mn
Published on 2010-04-19T16:54:26Z Indexed on 2010/04/19 17:03 UTC
Read the original article Hit count: 247

Filed under:

raid5

|

sql-server

|

windows-server-2008

Hello,

Actually I run RAID 5 (4 x SAS drives) with

Win 2008 Ent(1x host)
Win 2008 End(3x guest)
Sql Server 2005 Std (on guest)
3 x asp.net applications (on guest)

I bought 3 x drives to create additional array (on same controller E200i, I am waiting now for confirmation is it possible to have 3 raids in same controller)

I am planning to have 2 x RAID5 (if it is possible)

first RAID 5 with all vhd files, systems etc
second RAID 5 all data files and transaction logs

I am looking for opinion how to optimize data layer (seven drives, one controller).

© Server Fault or respective owner

Related posts about raid5

Server 2008 RAID5 resynching

as seen on Server Fault - Search for 'Server Fault'
I built a W2K8 R2 server last weekend, and built a R5 array using Disk Management, 5x 1TB drives. For the next 60 hours the status said 'Resynching (X%)' as it built the array. during this time i did read and write to the drive (slowly) and once the rebuild was complete speeds were quite fast. I… >>> More
HP DL380 RAID5 Mistake

as seen on Server Fault - Search for 'Server Fault'
I had drives fail in both logical drives on a server. When I replaced failed 146GB drive in Raid 5 array with four (4) 146GB drives. On reboot the Smart Array controller asked if I wanted to accept data loss. Guess mistake to choose yes. Can't seem to find a way to get system to repair RAID5 but… >>> More
How to stop RAID5 array while it is shown to be busy?

as seen on Super User - Search for 'Super User'
I have a raid5 array and need to stop it, but while trying to stop it getting error. # cat /proc/mdstat Personalities : [linear] [multipath] [raid0] [raid1] [raid6] [raid5] [raid4] [raid10] md0 : active raid5 sde1[3](F) sdc1[4](F) sdf1[2] sdd1[1] 2120320 blocks level 5, 32k chunk, algorithm… >>> More
How can I create a 4TB partition on my software RAID5 device?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have set up a RAID5 device with three 2TB hard drives using mdadm. The device was successfully created, but I cannot seem to create a partition on the device. When I try to make an ext3 or ext4 partition via Disk Utility, I get the following error Error creating partition: helper exited with exit… >>> More
Installing raid 5 on a pre-installed ubuntu server. 12.04

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have a ubuntu server with samba already set up and installed with a 1tb hdd. I am wanting to now install 3 more 1tb drives and create a raid array using raid 5. I have found a lot of documentation about installing raid when installing and setting up ubuntu server for the first time. However, I… >>> More

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More