Installing Multiple Instances Design Question

I have 4 small small SQL 2000 databases that I need to consolidate to a
single machine.
The data is minimal maybe 100 GB total with an expection of some
moderate growth.
The box will be configured with a raid 5.
Question:
Should the O.S and each instance be on its own partition?
Or would it be better to have the instances on one partition and
dedicate a partition for the data and log files?
Any inforomation would be greatly appreciated.
Thanks,
Hulicat
I would investigate if the four database could reside in the same server.
(Perhaps because of security or other needs, that is not possible.)
If you have to have 'separate' servers, install multiple instances of SQL
Server on the same box. All instances will use the same OS -the only thing
being 'duplicated' is SQL Server instances (code, settings, etc.)
Drives.
Best choice: RAID 1 for OS and SQL installables (2 drives). RAID 10 for data
files (4 drives). RAID 10 for Logs files (4 drives). For optimal
performance, each instance 'should' have its own drives for data and logs.
I wouldn't recommend trying to make everything work with a single RAID 5.
That would be painful.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Hulicat" <dennis_A_white@.yahoo.com> wrote in message
news:1162403869.339729.318940@.e64g2000cwd.googlegr oups.com...
>I have 4 small small SQL 2000 databases that I need to consolidate to a
> single machine.
> The data is minimal maybe 100 GB total with an expection of some
> moderate growth.
> The box will be configured with a raid 5.
> Question:
> Should the O.S and each instance be on its own partition?
> Or would it be better to have the instances on one partition and
> dedicate a partition for the data and log files?
> Any inforomation would be greatly appreciated.
> Thanks,
> Hulicat
>
|||~Thanks~
Arnie Rowland wrote:[vbcol=seagreen]
> I would investigate if the four database could reside in the same server.
> (Perhaps because of security or other needs, that is not possible.)
> If you have to have 'separate' servers, install multiple instances of SQL
> Server on the same box. All instances will use the same OS -the only thing
> being 'duplicated' is SQL Server instances (code, settings, etc.)
> Drives.
> Best choice: RAID 1 for OS and SQL installables (2 drives). RAID 10 for data
> files (4 drives). RAID 10 for Logs files (4 drives). For optimal
> performance, each instance 'should' have its own drives for data and logs.
> I wouldn't recommend trying to make everything work with a single RAID 5.
> That would be painful.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "Hulicat" <dennis_A_white@.yahoo.com> wrote in message
> news:1162403869.339729.318940@.e64g2000cwd.googlegr oups.com...