Chewy509
Wotty wot wot.
Hi Guys,
I've recently inherited a fileserver (SBS2003), who's main duties are fileserving and MSSQL2K for the Point of Sale (POS) System and Intranet/Sharepoint.
The POS was installed at the same time we inherited the management of the server.
Long story is, they are receiving numerous SQL timeout errors with POS software, and I've narrowed it down to the disk sub-system. (Problem only occurs when all 5 tills are operating, eg under heavy load). The array can't keep up with MSSQL's demands.
The current config is 3x 10K 74GB SCSI (Maxtor) in RAID5, and is only achieving approx 25MB on writes, with some bursts up to 40MB.
Since I know RAID 5 suffers from low-write performance (which is affecting MSSQL), would like to offer a solution, that is migrate to RAID10, providing they purchase another drive. (The current array has 80GB of data).
I've read through the LSI documentation, and cant' find either:
1. The LSI 320-1 controller offer RAID Level Migration? (it can migrate from RAID5 to RAID10 without loss of data, providing enough storage space is available in final RAID level).
2. or, I need to destroy the array, and rebuild from scratch.
Anyone have an idea?
PS. I'll be backing up the server before starting anyway... but don't want to have to ghost several times just to migrate the RAID levels.
I've recently inherited a fileserver (SBS2003), who's main duties are fileserving and MSSQL2K for the Point of Sale (POS) System and Intranet/Sharepoint.
The POS was installed at the same time we inherited the management of the server.
Long story is, they are receiving numerous SQL timeout errors with POS software, and I've narrowed it down to the disk sub-system. (Problem only occurs when all 5 tills are operating, eg under heavy load). The array can't keep up with MSSQL's demands.
The current config is 3x 10K 74GB SCSI (Maxtor) in RAID5, and is only achieving approx 25MB on writes, with some bursts up to 40MB.
Since I know RAID 5 suffers from low-write performance (which is affecting MSSQL), would like to offer a solution, that is migrate to RAID10, providing they purchase another drive. (The current array has 80GB of data).
I've read through the LSI documentation, and cant' find either:
1. The LSI 320-1 controller offer RAID Level Migration? (it can migrate from RAID5 to RAID10 without loss of data, providing enough storage space is available in final RAID level).
2. or, I need to destroy the array, and rebuild from scratch.
Anyone have an idea?
PS. I'll be backing up the server before starting anyway... but don't want to have to ghost several times just to migrate the RAID levels.