Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kristen
Test
22859 Posts |
 Posted - 2007-03-20 : 14:15:39
|
| We have a server with some pesky RAID5 - which has on 3 separate occasions corrupted the Databases when a drive failed. So we had a maintenance window and decided to change it to RAID10.We started the configuration at 13:00 today, its now 18:00 and it has done 25% ... is that normal?Its 8 disks (so 4 mirror-pairs), it will have around 300GB of usable space when its done.What would happen if we needed to do this in a time critical window? (for this debacle we have moved the database onto the Web Server, so we can survive for a few more hours ...)Kristen |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-03-20 : 15:48:49
|
| I'll bet SAN sounds good right now.CODO ERGO SUM |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-21 : 02:35:28
|
Yeah, well thanks for the very helpful advice MVJ  I'll send you a PayPal Donate URL in a moment ... ;)Stupid thing logged the Start Time for the Initialise in the Event Log ... but not the end time ... so I don't know what time of the night it finished Is my "local" disk storage going to be faster, for SQL server, than a SAN?And even if the answer is "yes" should I care?Kristen |
|
|
|
nwalter
Starting Member
39 Posts |
Posted - 2007-03-23 : 13:14:29
|
| The simple answer is no, I don't know of any local or DAS systems that can come even close to the performance of most SANs. But it really all comes down to spindle speed and quality of the disks. A SAN with cheap disks and only a few spindles will most likely perform on par with your basic local or DAS system using only a few spindles and cheap disks.Where a SAN will really shine is when you start loading it up with 40+ fibre channel high speed drives. All of this attached to a fiber based infrastructure will move terabytes per second. Of course you're talking a $300,000 starting price tag for something like that too. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-24 : 01:52:18
|
| "Of course you're talking a $300,000 starting price tag for something like that too"Excellent! I'll have two please!Thanks for the comparative info on SANs v. Local.Kristen |
|
|
|
|
|
|
How Quickly Does RAID10 Format?