|
Home > Archive > MS SQL Server > October 2006 > Re: RAID & Drive Type for Server?
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 |
Re: RAID & Drive Type for Server?
|
|
| Linchi Shea 2006-10-25, 6:00 am |
| One small caveat though, if a small database does a lot of writes, you can
still stress the I/O subsystem.
Linchi
"Andrew J. Kelly" wrote:
> I tend to agree with Linchi given the small size of the db. Most if not all
> of the data should be in cache anyway so there should be very little disk
> I/O on a constant basis.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Don Miller" <nospam@nospam.com> wrote in message
> news:eAH7N0W9GHA.3348@TK2MSFTNGP03.phx.gbl...
>
>
>
| |
| Don Miller 2006-10-25, 6:00 am |
| Thanks for the quick reply yesterday and for your thoughts.
"Linchi Shea" < LinchiShea@discussio
ns.microsoft.com> wrote in message
news:A93579B9-CD81-4E39-89AA- 8955C05CB114@microso
ft.com...[color=darkred]
> One small caveat though, if a small database does a lot of writes, you can
> still stress the I/O subsystem.
>
> Linchi
>
> "Andrew J. Kelly" wrote:
>
all[color=darkred]
disk[color=darkred]
(IIS,[color=darkred]
is[color=darkred]
3gb+[color=darkred]
two[color=darkred]
is[color=darkred]
etc.[color=darkred]
rpm,[color=darkred]
or[color=darkred]
the[color=darkred]
read-writes is[color=darkred]
until[color=darkred]
but[color=darkred]
compared[color=darkr
ed]
RAID 5[color=darkred]
of[color=darkred]
|
|
|
|
|