|
Home > Archive > MS SQL Server > April 2005 > RAID 1 Configuration
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
RAID 1 Configuration
|
|
|
| We are going to deploy a SQL Server 2000 for an
application which information is static. We just provide
queries for end users.
In order to minimize the backup procedure, we would like
to use RAID 1 mirroring configuration. Is this choice OK ?
| |
| aramid 2005-04-07, 7:01 am |
| Your backup procedure has nothing to do with your choice of RAID
configuration (unless I'm missing something here). Performance and
Redundancy has.
Aramid
On Wed, 6 Apr 2005 22:50:08 -0700, "Peter"
< anonymous@discussion
s.microsoft.com> wrote:
>We are going to deploy a SQL Server 2000 for an
>application which information is static. We just provide
>queries for end users.
>
>In order to minimize the backup procedure, we would like
>to use RAID 1 mirroring configuration. Is this choice OK ?
| |
|
| We will make a backup of whole drive once a week as the
data is static.
The reason why we think RAID 1 is because we think that if
one of the disk breaks down, the other one still works
properly.
Re the performance issue, we would like to know what is
the pros and cons of RAID 1.
Thanks
>-----Original Message-----
>Your backup procedure has nothing to do with your choice
of RAID
>configuration (unless I'm missing something here).
Performance and
>Redundancy has.
>
>Aramid
>
>On Wed, 6 Apr 2005 22:50:08 -0700, "Peter"
>< anonymous@discussion
s.microsoft.com> wrote:
>
provide[color=darkre
d]
OK ?[color=darkred]
>
>.
>
| |
| Mike Epprecht (SQL MVP) 2005-04-07, 7:01 am |
| Hi
The more spindles you have, the better your performance.
RAID-1 is good for performance and tolerance to failure, but RAID-10 (Or
0+1) is much better as it is striped and mirrored. So, you have the benefit
of Mirroring, plus you have multiple drives doing requests at the same time.
SCSI, not IDE or SATA.
Hardware mirroring, not software.
RAID-5 is evil, don't go there.
SQL Serrver does it's IO in 64k blocks (8 extents of 8k pages), so format
NTFS using 64Kb blocks.
Regards
Mike
"Peter" wrote:
> We will make a backup of whole drive once a week as the
> data is static.
>
> The reason why we think RAID 1 is because we think that if
> one of the disk breaks down, the other one still works
> properly.
>
> Re the performance issue, we would like to know what is
> the pros and cons of RAID 1.
>
> Thanks
>
> of RAID
> Performance and
> provide
> OK ?
>
|
|
|
|
|