Raid 0 is effective for sql 2000?

[Mttc]

I have SQL2000 with 3G DB file size.


How mach is effective raid 0 (or raid 10) for such Application?

Have some one with experience?

 

[Peter]

I have SQL2000 with 3G DB file size.

How mach is effective raid 0 (or raid 10) for such Application?

Have some one with experience?

Effective for what? Performance, reliability?
For both, deploy multiple disks with high IO/s in RAID10.

 

[Odie Ferrous]

I have SQL2000 with 3G DB file size.

How mach is effective raid 0 (or raid 10) for such Application?

Have some one with experience?

A standard, recommended setup for a SQL server is OS and apps on RAID 1,
and the databases on RAID 5.

RAID 0 is quick, but most definitely not advisable.

Odie

 

[Mttc]

My Q is:

if we assumed that our Raid 5 configuration gives Multiple performance

Of 1 disk (for example 90MBps), that true only for Large sequence IO.


But how I can estimate how it increase performance of SQL server

(with 5G Data file)?


I can consider as add 30% performance to original?

 

[Peter]

My Q is:

if we assumed that our Raid 5 configuration gives Multiple performance
Of 1 disk (for example 90MBps), that true only for Large sequence IO.
But how I can estimate how it increase performance of SQL server
(with 5G Data file)?
I can consider as add 30% performance to original?

In general, for database performance you need IO/s not MB/s.
Did you collect performance statistics from your current database?
How is your current RAID5 configured (what disks - model number
and how many does it have?)
How do you measure performance of your database?