I recently assumed a role where I am responsible for the database server.
This database is SQL 2005 with MS Dynamics 10 running on top of .it, running server 2003.
I was looking at the configuration and noticed that all 8 drives are setup as raid 5, the performance is terrible.
I was thinking in my limited experience that a mirrored primary C:// drive with the other 4 in a raid 5 configuration? Not sure waht hte other 2 drives would be doing.
Am i mislead and to lead the database running raid 5? If I am correct in wanting to reconfigure the server what is the best way to change the production server after hours to the appropriate or optimal configuration?