RAID 0+1 and DB performance 
Author Message
 RAID 0+1 and DB performance
By what order of magnitude will segment fragmentation and/or free space
fragmentation degrade DB performance?  If we are using RAID 0+1, will
there still be such degradation or will RAID counter whatever problmes
fragmentation incur on the database?

Sent via Deja.com http://www.***.com/
Share what you know. Learn what you don't.



Wed, 18 Jun 1902 08:00:00 GMT
 RAID 0+1 and DB performance

Quote:

> By what order of magnitude will segment fragmentation and/or free space
> fragmentation degrade DB performance?  If we are using RAID 0+1, will
> there still be such degradation or will RAID counter whatever problmes
> fragmentation incur on the database?

> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Go to www.europa.com/~orapub

There are some very good papers on fragmentation etc etc...Get it right
first time and you will NEVER have a problem, and NEVER have to do a
reorg...

HTH
--
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"

"Some days you're the pigeon, and some days you're the statue."



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. RAID 5 write performance versus RAID 1

2. RAID 1+0 with RAID 5 or RAID 0+1 with RAID 5

3. To RAID or not to RAID (...or how to RAID)

4. Raid 0+1 Versus Raid 1 (Raid Again)

5. disk performance with all devices on 1 logical RAID drive

6. RAID + SQL performance question

7. Best SQLServer Server Performance w/ RAID

8. Raid Performance

9. RAID Performance

10. Performance boost by RAID controllers and filegroups

11. PERFORMANCE: SQL Server 6.5 and RAID subsystem

12. Input needed on RAID 5 performance effects


 
Powered by phpBB® Forum Software