Hi,
I have a brand new HP 380 Server.
This will server will house the databases for several different OLTP
applications.
Some are moderately used, others are not. Averaging about 60 concurrent user
s.
There are 6 disks available. 2 are 72 GB each, the other 4 are 144GB each.
I have decided to mirror the 72's for the OS and Microsoft SQL Server 2000
program files.
I need valuable suggestions for the 4 remaining disks.
Should I:
Option 1. create two more mirrored pairs - one for the data and 1 for the lo
g.
or
Option 2. RAID 5 for the remaining disk - put the data on the RAID 5 and the
log on the initial mirrored pair.
I'm heading more towards 1 as disk space, based on current usage space won't
be an issue for quite some time.
Recommendations or comments are most welcome.
Thanks!Hi
You may want to check out other posts on this subject! Also read
http://msdn.microsoft.com/library/d... />
1_87jm.asp
I would not go for option2 as this is limiting the log files to the smallest
discs, there is also option 3 which is put everything on Raid 5, which will
be more resilient but slower than option 1.
John
"gracie" <gracie@.discussions.microsoft.com> wrote in message
news:9EA03E97-626D-4976-AB79-3A788D0E0BC7@.microsoft.com...
> Hi,
> I have a brand new HP 380 Server.
> This will server will house the databases for several different OLTP
> applications.
> Some are moderately used, others are not. Averaging about 60 concurrent
> users.
> There are 6 disks available. 2 are 72 GB each, the other 4 are 144GB each.
> I have decided to mirror the 72's for the OS and Microsoft SQL Server 2000
> program files.
> I need valuable suggestions for the 4 remaining disks.
> Should I:
> Option 1. create two more mirrored pairs - one for the data and 1 for the
> log.
> or
> Option 2. RAID 5 for the remaining disk - put the data on the RAID 5 and
> the
> log on the initial mirrored pair.
> I'm heading more towards 1 as disk space, based on current usage space
> won't
> be an issue for quite some time.
> Recommendations or comments are most welcome.
> Thanks!
>|||Hi
These may be of interest!
http://tinyurl.com/96l7b
John
"gracie" <gracie@.discussions.microsoft.com> wrote in message
news:9EA03E97-626D-4976-AB79-3A788D0E0BC7@.microsoft.com...
> Hi,
> I have a brand new HP 380 Server.
> This will server will house the databases for several different OLTP
> applications.
> Some are moderately used, others are not. Averaging about 60 concurrent
> users.
> There are 6 disks available. 2 are 72 GB each, the other 4 are 144GB each.
> I have decided to mirror the 72's for the OS and Microsoft SQL Server 2000
> program files.
> I need valuable suggestions for the 4 remaining disks.
> Should I:
> Option 1. create two more mirrored pairs - one for the data and 1 for the
> log.
> or
> Option 2. RAID 5 for the remaining disk - put the data on the RAID 5 and
> the
> log on the initial mirrored pair.
> I'm heading more towards 1 as disk space, based on current usage space
> won't
> be an issue for quite some time.
> Recommendations or comments are most welcome.
> Thanks!
>|||Do you have RAID 10 available as an option? If you aren't concerned about
space, are considering mirroring, AND have four disks available then you
definitely should be considering this as an option if your RAID controller
supports it. BTW, what type of RAID controller are you using for this? Do
you have stats on cache, RAID supported, etc?
Do you have any idea of the total IOPS this system is going to need to
support? Is the overall system more read intensive or write intensive? Wha
t
is the estimated ratio?
Derrick Leggett
Mean Old DBA
http://weblogs.sqlteam.com/derrickl
When life gives you a lemon, fire the DBA.
"John Bell" wrote:
> Hi
> These may be of interest!
> http://tinyurl.com/96l7b
> John
> "gracie" <gracie@.discussions.microsoft.com> wrote in message
> news:9EA03E97-626D-4976-AB79-3A788D0E0BC7@.microsoft.com...
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment