Raid 0 is effective for sql 2000?

  • Thread starter Thread starter Mttc
  • Start date Start date
M

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?
 
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?
Click to expand...
Effective for what? Performance, reliability?
For both, deploy multiple disks with high IO/s in RAID10.
 
Mttc said:
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?
Click to expand...

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
 
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?
 
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?
Click to expand...

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?
 
Back
Top